I have to upgrade and move SQL Server 2000 databases from a platform using Server 2000 to one running SQL Server 2005. The server name\instances will need to be the same so that a number of third party applications and front end systems that connect, and are outside of my control, will not need any data source changes. The servers will be on the same network and can't co-exist with the same name so I guess that I have to go "big bang".

Does anyone have any suggestions for a strategy that I can use?
Does anyone know of any issues that I should be aware of?

I have run the SQL Server 2005 Upgrade Advisor and it tells me the databases should upgrade OK with a few minor issues that can be fixed after.

Thanks,


george

George, you should be "good to go" as is. You should be able to dettach the database from SQL Server 2000 and re-attach it to the SQL SErver 2005 database. Once you have attached the database to SQL Server 2005, go in and set the Compatability Level (found on the properties of the database). It may automatically set it for you.