![]() I followed Rich's solution above and it worked great! Thanks - I can't vote up yet in here! This property is not available on SQL Server 7.0." SQL Management Object Method which failed with errorĬannot read property IsFileStream. StackTrace: at .PropertyBag.SetValue(Int32 index, Object value)Īt .DataFile.get_FileName() "Detach and Attach", which failed with error: Message: Index was outside the bounds of the array. I also tried the "Copy Database Wizard", which claimed to be able to copy "from 2000 or later to 2005 or later". Unfortunately it spends ages generating its scripts, then fails with errors like "Failure inserting into the read-only column 'FOO_ID'". I selected all my tables (300+), and clicked through the wizard. This didn't include any of the data, though.Īfter creating that schema on my 2008 machine, I was able to open the "Export Data" wizard on the 2012 machine, and after configuring the 2012 as source machine and the 2008 as target machine, I was presented with a list of tables which I could copy. I tried Tasks → Generate Scripts on the 2012 server, and I was able to generate the schema (including stored procedures) as a SQL script. It contains tables, data and stored procedures. The database does not use any 2012 specific features. Is there an easy way to export the schema and data to a version-agnostic format which I can then import into 2008? I cannot find any options in 2012 to create a 2008 compatible backup. ![]() The 2008 server cannot restore backups created by a 2012 server (I have tried). I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |