Upgrade from 32-bit SQL 2000 to SQL 2008 64-bit

I have several databases on Windows 2000 Server running SQL Server 2000 32-bit. I need to migrate all data and settings to a new server running SQL 2008 64-bit on Windows 2003 64-bit.

It's as easy as backing up your databases and restoring to a new server. Will this work with system databases (master, model, msdb)? If not, is there a way to automate the process of navigating user accounts and permissions?

Does anyone know of any other errors?

Thanks a lot for any help.

[EDIT] I have successfully tested the upgrade to 32-bit SQL2008, I am mainly interested in the 64-bit differences since I don't have a 64-bit server that I can check on at the moment eg I know to restore the database SQL2000 not possible until 2008; can you restore 32bit SQL2008 server to 64bit SQL2008? Downtime during migration is not an issue.

+1


source to share


2 answers


To transfer logins, you can use the "Login Transfer Task" described in the "Online Books" book here .

Ross Meester has published several articles in the SQL Server 2008 Installation Strategies and Best Practices section. Also this document , although intended for specific equipment, contains useful information.



EDIT: Have you looked at the Microsoft SQL Server 2008 Upgrade Advisor ?

+1


source


I would use RedGate SQL Compare and SQL Data Compare. This will give you some guarantees on the integrity of the database. However, this will not be an interactive data migration, you will need to prevent updates during the migration.



-2


source







All Articles