My company is currently using MS Sql Server 2000 for applications, and in Windows Server 2000. The database holds great amount of information.
Recently, my company needs to migrate database from Sql Server 2000 to 2005. How could I safely migrate the database from sql server 2000 to 2005? Could you all give me the guides?
Also, in what aspect I should pay attention on the performance of sql server 2005?
Thank you for your kind attention.
Best Regards,
David
Hi,
You can find lot of information about the upgrade at here: http://www.microsoft.com/sql/solutions/upgrade/default.mspx
I highly recommend to use the upgrade advisor, it helped me a lot.
Regards,
Janos
|||you have the following options to migrate to sql 2005,
1.Inplace upgrade > it will overwrite the current sql 2000 instance and a new sql 2005 instance will be created, but as replied by previous member you need to run the upgrade advisor to ensure that everything is fine with your db b4 upgrading
2.Side by Side upgrade > it is the most conventional method, you can use any of these below methods ......i prefer backup and restore
backup your SQL 2000 db and restore it in sql 2005 detach your sql 2000 db and attach it in sql 2005 use copy database wizard to move your sql 2k dbs to sql 2k5
No comments:
Post a Comment