de-DEen-US
Blog_List
The blog about Microsoft products by Matthias Schlomann
 Matthias Schlomann
 18  3641  12/9/2015
Categories
Blog

Query and modify the database compatibility level to SQL DNN

By Matthias Schlomann on 11/6/2013

Since DNN Platform / evoq 7.0 of the SQL Server 2008 is a minimum requirement for DNN Platform and evoq editions. When upgrading the database or changing to another MS SQL Server compatibility level is not changed automatically , and has to be done manually. For this one can on the Execute SQL feature in DNN create a query in query system to obtain the compatibility level .


 

For this purpose, the following command can be executed ( <databasename> be replaced by the database name ! ):

 

Select compatibility_level
From sys.databases WHERE name = ' <databasename> ';

 

As output we get the following values ​​:

 

110 = MS SQL Server 2012/2012 R2
100 = MS SQL Server 2008/ 2008 R2
90 = MS SQL Server 2005

80 = MS SQL Server 2000

and is approximately as shown :

compatibility_level
90

 

In this case, the compatibility level on MS SQL Server 2005 is set and should be set to at least 100, so that the minimum requirements for DNN 7.0 are met.

However, that we can change this with safety , we need a MS SQL Server 2008 or later . We should then opt for the highest degree of compatibility . The SQL Server version we can check the 'System Info ' function without prompting with the system.

If we assume that a MS SQL Server 2012 is used , we should now set the compatibility level to 110. This can also be performed using the Execute SQL function under System as a script query.

 

The query should look like this ( <databasename> must be replaced by the database name! ) and 'Run as script' have to be enabled:

 

ALTER DATABASE <databasename>
 SET COMPATIBILITY_LEVEL = 110;
GO

We can now perform the previous code again to check whether the change was made.
Now upgrading to DNN 7.x can be start .

 

Blog_Archive
Blog_Tags
Privacy Statement | Terms Of Use | © 1994-2024 by AARSYS - Matthias Schlomann