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!!!

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 

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

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?

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

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

OK, thanks everybody, I will try to find some manual to dont have any problems, If you know someone please write it.

Thanks!

May be the below links would help you:

http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx

http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf