Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 to SQL 2012 migration Expand / Collapse
Author
Message
Posted Monday, December 19, 2011 1:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, December 14, 2014 6:28 PM
Points: 161, Visits: 485
Is it possible to migrate from SQL 2000 to SQL 2012 directly? Looks like direct upgrade using setup is not possible as per the below link:

http://msdn.microsoft.com/en-us/library/ms143393(v=sql.110).aspx

But is it possible to migrate using backup and restore? For example, set up a new 2012 instance, create all logins and other required objects and finally restore SQL 2000 DB backups.

Thanks in advance.
Post #1223658
Posted Monday, December 19, 2011 1:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, December 14, 2014 6:28 PM
Points: 161, Visits: 485
I tried backup and restore option, that is also erroring out. Is there any other direct way of upgrading from 2000 to 2012 other than having an intermediate 2008/2008 R2 instance and again backing up from there and finally restoring on 2012 instance?
Post #1223669
Posted Monday, December 19, 2011 1:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
I would try using SSIS to import the SQL 2000 database.
I can't try myself right now, but I would think that's your best bet.


Markus Bohse
Post #1223673
Posted Monday, December 19, 2011 2:30 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:43 AM
Points: 882, Visits: 4,144
No. To upgrade any database to 2012 which is below 2005, you have to first upgrade the database to 2005/2008 and then only will be able to upgrade to 2012.


----------
Ashish
Post #1223680
Posted Friday, December 30, 2011 3:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 30, 2011 6:21 AM
Points: 21, Visits: 59
I did a couple of 2000 to 2012 migrations in a current project and it works really good to go by 2008 R2 instance. If you do the restore by T-SQL you can see the upgrades being done to the database. Don't forget to set the compatibility level to 110 afterwards.
Post #1228227
Posted Wednesday, February 15, 2012 9:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:38 AM
Points: 241, Visits: 1,203

U can't migrate please follow below link

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/4dddd9e9-a34f-43d0-89bc-86672bebf52f

Tx

Post #1252563
Posted Monday, March 5, 2012 5:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 22, 2014 3:53 AM
Points: 13, Visits: 88
MarkusB (12/19/2011)
I would try using SSIS to import the SQL 2000 database.
I can't try myself right now, but I would think that's your best bet.


Hey MarkusB!

If I am not mistaken SSIS wasn't there in SQL 2000, I believe you are referring to DTS.

That actually gives me an idea to move the 2000 DB to 2005 / 2008 instance (DTS -> SSIS) then move the new database to 2012. Any ideas ?!?!

Sorry I cannot try this myself as I do not have 2000 instance
Post #1261528
Posted Monday, March 5, 2012 5:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:35 PM
Points: 12,962, Visits: 32,498
what he meant was your SSIS in 2012 can connect to any SQL 2000 instance, and thus do the database migration.
no need to use DTS and then SSIS if SSIS alone could do all the work.


I'd stick with the suggestions relating to restoring the database on a 2008 or R2 instance, then doing a backup and restoring that on your 2012 instance.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1261531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse