Sample Header Ad - 728x90

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