Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Copy Database Wizard .... Missing!


    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!


  2. #2
    Join Date
    Sep 2003
    copy 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts