How to move a database from SQL Server 2012 to SQL Server 2005
34
votes
4
answers
23230
views
What are my options if I need to move a database from SQL Server 2012(32bit) to SQL Server 2005(64bit)?
I know I cannot:
- restore a backup of the database on SQL Server 2005
- detach & attach
I know I can:
- use import data wizard, and I tried it on one database, but it only moves data, and even that was troublesome as I needed to do a lot of work creating temp tables to maintain identity columns, recreating all FKs, indexes etc.
Is there an easier option?
Asked by Greg Bala
(1025 rep)
Dec 15, 2013, 02:56 PM
Last activity: May 26, 2019, 01:31 PM
Last activity: May 26, 2019, 01:31 PM