Menu
What is the best way to use SQL Server 2008 as a development database, but ensure that the database is compatible with SQL Server 2005?
909
SQL Server 2008 R2 is not supported on Windows 10 or Windows Server 2016. SQL Server 2008 is not supported on Windows 10 or Windows Server 2016.
SQL Server compatibility level is one of the database settings. It helps to keep the database compatible with SQL server versions. By default compatibility level of the database is lower than the SQL server version. It impacts many objects in the server.
Generally yes. Your services on 2008 R2 will continue running normally unless you manually make some changes. Only impact that sql 2012 can have is if you plan to run some performance intensive operations but nothing else apart from that.
After 10 great years, extended support for all versions of SQL Server 2005 is coming to an end on April 12, 2016.
This can be done via SQL Enterprise Manager or like this:
ALTER DATABASE <database>
SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }
Use 90 for 2005 compatibility.
This replaces the functionality used for previous releases, the stored procedure sp_dbcmptlevel.
112
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
