Friday, March 26, 2010

SQL Server - Restoring 2008 Backup to 2005!

Having developed and populated a signicantly large database on my local SQLEXPRESS 2008 installation, I thought it would be a sinch to back it up and get our DBA to restore it to our SQL Server 2005 cluster - how wrong was I...

Determined to get around the problem without having to manually re-do any of the work to create or populate the database, I tried the following and it worked a treat:
  • SQL Management Studio 2008 - right-click on Database > Tasks > Generate Scripts... - select Script Data and any other relevant options
  • Create a batch file to execute each of the SQL scripts using SQLCMD

No comments: