Background:
Running SQL 7, have to move a database to someone else's server. They are running 2000.
Looks like the easiest way to do this is with the Copy Database Wizard!
Stupid Question 1: My SQL 7 Enterprise Manager doesn't have Copy Database Wizard listed in it's tasks for the server, per the instructions. Any idea why it's not?
Stupid Question 2: Are there any issues with using this procedure (assuming I can get the wizard to show itself) to transfer a 7 database over to 2000?
Many thanks!
Jerrekcopy database wizard is a fancy gui for detaching the db, copying mdf/ndf/ldf over, attaching db on both servers. check sp_detach/attach_db in bol.sqlsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment