Moving a SQL database from SQL 2000 to SQL 2008
Posted on 2008-10-30
I am upgrading web servers (I am a small site designer). Part of the upgrade is moving from a dedicated SQL 2000 server from one hosting company to a dedicated SQL 2008 server with another hosting company. What is the best way to transfer the databases from one to the other while still retaining the ownership, roles and permissions necessary to make sure I don't have to rewrite a lot of stored procedures.
Any advice is welcome - I am attempting one of the moves tonight.