dowhatyoudo22
asked on
How to move a SQL database
I have two database instances running on a SQL 2000 SP3 Server. I need to move these database instances to a another server running SQL Server 2008 R2. How/what is the best way to achieve this move?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
documentation seems to be focused on SQL 2005 -> SQL 2008. I'm wondering if the same rules apply to SQL 2000 SP3 -> SQL 2008 R2?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I personally would use the database export on the old server and then import the databases on the new server, though using the wizard in option 3 sounds interesting.