April 6, 2014 at 8:34 pm
I have a windows server 2000 and SQL Server 2000. how to move the data from sql 2000 to sql 2012. Please provide a way for this problem. thanks for the help
regards
oderudin
April 6, 2014 at 9:45 pm
Please provide more information on what you want/need to do...
Are you just moving the data from one database into another one?
Are you wanting to upgrade the server and SQL Server instance to 2012?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 7, 2014 at 3:58 am
(Sorry; I keep generating duplicate posts.)
April 7, 2014 at 3:58 am
Well, a backup and restore is probably simplest. You can't restore a 2000 backup straight to 2012, so do you have a 2005/2008/2008 R2 instance you can restore to first?
April 7, 2014 at 11:08 am
Depending on how complex or simple your tables are..... You might be able to simply script out the tables and then use the import/export GUI to move the data.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply