Datas from SQL Server 2000 to 2012
Hi!
I have 2 virtual systems with software that works with SQL server, one of then with SQL server 2000 and the other with 2005. Now I want to have only one machine with SQL server 2012 and the each software in an individual virtual machine.
How can I make the change? Can I just export the db from 2000 and 2005 to 2012, test it, and finally connect with the machines?
Thank you!!!
February 5th, 2014 5:05am
I believe you have a new server where SQL 2012 is installed and you want to move the data from sql 200o to 2012.
You can do this either by import export wizard or , using SSIS
February 5th, 2014 5:09am
You can not restore 2000 database directly to 2012. You need to first restore it to SQL Server 2005 and then migrate to SQL Server 2012. I think, that should do the trick.
- Marked as answer by
Jonaycp
38 minutes ago
February 5th, 2014 5:11am
The method passing for 2005 in just for upgrading sql server or I have to do it if I just want change the info to my new sql server machine?
February 5th, 2014 5:38am
Hi
Like Latheesh said, you need to upgrade to 2005 first just for upgrading purpose, as you cannot upgrade from 2000 directly to 2012.
Cheers
Mani@YourSQLMan.com
February 5th, 2014 5:41am
The method passing for 2005 in just for upgrading sql server or I have to do it if I just want change the info to my new sql server machine?
I dont get the question.
Backup created from SQL Server 2000 will not be compatible to restore directly in SQL Server 2012 where as its possible in SQL Server 2005. So you need to first restore to SQL Server 2005 and then take backup of the database from 2005 and then restore in
SQL Server 2012 instance.
- Marked as answer by
Jonaycp
37 minutes ago
February 5th, 2014 5:42am
OK, thanks everybody, I will try to find some manual to dont have any problems, If you know someone please write it.
Thanks!
February 5th, 2014 5:55am
February 5th, 2014 6:10am