My Cart (0)  |  My Orders  |  My Downloads  |  My Auction  |  My Account  |  Help


Login |Register        Search

Check SQL database compatibility level before Upgrading to DNN 7.x

                Print      Add To Favorite     Add To Watch List     Contact Author

Creator: host   5/15/2014 3:51:18 AM    Author: Matthias Schlomann   Source: http://www.dnnsoftware.com/community-blog/cid/154944/check-and-upgrade-sql-database-compatibility-level-before-upgrading-to-dnn-7x-using-dnn-sql   Views: 2264    0    2  
Tags:
SQL Dnn upgrade dnn 7


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 200580 = 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 .


Rating People: 2   Average Rating:     

     DnnModule.com is built to provide DNN quality modules and DNN skins, some of them are free, some not. We wish these stuffs (free or not ) can be useful to you.

     Besides that, we also provide a full range of professional services, ranging from web site build, seo, system management, administration, support, senior consultancy and security services. We act as if your development project or network was ours, with care and respect. We are not satisfied until it works the way you want it to, and we don't silently ignore found issues as somebody else's problem.