I have a production box with SQL Server 2008, and I'm looking to consolidate my DEV server with another that's running 2005. So my question is, are there any options I can set that will allow me to restore the production dump of 2008 to my new dev on SQL 2005?
Thanks!
Best Answer
No, you can't. The databse formats are incompatible. About the best you can do is script out the database and export the data. Note, though, that some things (like certain datatypes) that are new to SQL 2008 will throw your 2005 instance for a spin.