Menu
Currently, one of our product running on the SQL Server 2008R2.
For new installation client want to go for SQL Serer 2014 because at this location Microsoft is not selling licence for the SQL Server 2008R2.
313
Yes, SQL Server is backward compatible. You can restore a database from any previous version of SQL Server that was supported at the time of the release. For SQL Server 2017, you can therefore restore databases from SQL Server 2008 to 2017. SQL Server, however, is not forward compatible.
A backup taken on SQL Server 2008 and later, can be restored to SQL Server 2019 (15. x) without changing its compatibility level, as long as the database backup has a compatibility level of 100 or higher.
The harsh and direct answer would be no, you cannot downgrade. You said scripting out and exporting data doesn't work, did you try to set the database compatibility mode to 2014. Then script out the database and create it on 2014 server.
Yes you can directly migrate to SQl 2016 either attach/deattach or backup and restore.
In SQL Server 2014, you can restore a user database from a database backup that was created by using SQL Server 2005 or a later version. However, backups of master, model and msdb that were created by using SQL Server 2005 through SQL Server 2012 cannot be restored by SQL Server 2014. Also, backups created in SQL Server 2014 cannot be restored by any earlier version of SQL Server.
Source
87
Yes.
Wen you restore database backup that created with older version of SQL Server in to new version, SQL Server automatically updated your database in new version. But don't change compatibility level of your database. You can change Compatibility level of your database after restore complete by following query :
ALTER DATABASE test SET COMPATIBILITY_LEVEL = 120
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
