Downgrade Sql server database
-
Is there any utility or mode to convert a sql server database to a lower version. For example From sql server 2008r2 to sql server 2005 ? Thank you !
No, if you have not used any of the version specific functionality in the 2008 DB you could script out the database and use something like Red-Gate Compare and Data Compare to move the data across. Also I think you can set the compatibility on the server, that may help.
Never underestimate the power of human stupidity RAH
-
Is there any utility or mode to convert a sql server database to a lower version. For example From sql server 2008r2 to sql server 2005 ? Thank you !
You can't downgrade using a backup file. The only way is to use scripting: How To Convert SQL Server 2008 Database To SQL Server 2005?[^] or some comparison tools like Red Gates's SQL Compare and SQL Data Compare: SQL Compare 10[^] SQL Data Compare 10[^].