Adjusting SQL Compability level, is it safe?

Ørjan Horpestad

Vote:

When doing a 7 -> 7.5 update I had some issues. Executing "update-epidatabase" in the package manager console showed me the following error message:

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help
for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

So I tried changing the compability level of the database from SQL Server 2000 (yeah, the database is pretty old) to 2008, and the update script executed successfully.

However - I'm wondering if this may have some unwanted side-effects that I should be aware of when I do this in our live environment?

#90973

Sep 23, 2014 12:29

Quan Mai

Vote:

I believe there is no side effect for this, if you have no plan to access your database from old SQL Server version. Indeed, it should not be related to EPiServer at all, only the MERGE keyword exposed the issue:

http://msdn.microsoft.com/en-us/library/bb510680.aspx

#90980

Sep 23, 2014 12:57

Ørjan Horpestad

Vote:

There is no plan accessing the db from older SQL Server versions, so I guess we're good. Thank you.

#91021

Sep 24, 2014 11:31