Moving a Database

Giganews Newsgroups
Subject: Moving a Database
Posted by:  Gene Wirchenko (gen…@ocis.net)
Date: Wed, 02 May 2012

Dear SQLers:

    What is the proper way for moving a database from location to
location?

    I put together a simple database, backed it up, and sent it to
the other location.  It will not restore.  (No, I was not told the
error message.)  My opposite number says that the database is supposed
to be unattached and attached, but he does not know all the ins and
outs either.

    How can I simply create a database and send it elsewhere, or
receive one from elsewhere and then have it get installed on the
destination?

    Scripts are not acceptable in this case as the databases will
eventually be operational databases, and we need to cover this.  For
debugging purposes, I may need to receive and install a full database.

Sincerely,

Gene Wirchenko

Replies