Transfer a Sequel 7.0 Database

You can only have one MASTER. Make a synchronized or replicates copy on the new server, and then set whichever to whatever is needed for user access.

Backup the Db from the old server, and restore it to the new server. You then need to stop the old SQL server (or rename the DB on it) so no-one picks up the wrong copy.

If you use SQL logons, then you have to write a short simple script to create all the users on the new SQL server (I think you might even be able to generate it off the old one).

Everyone who access the Db will have to update thier ini files/odbc settings etc to point to the new server.

The easiest way to transfer a db from one SQL Server to another is with DTS (Data transfer services). Like this, using Enterprise Manager:

1. Find the database on it's current server and right click on the name.
2. On the popup menu, highlight All Tasks.
3. Click on Export Data ...
4. Click Next.
5. The source SQL Server and database should be selected already, select if not and click Next.
6. Select destination server and select as database name.
7. Gice the database a name and set the start size for the db and log file and Click OK.
8. Click Next.
9. Select Transfer objects and databetween SQL Server 7.0 databases and click Next.
10. Explore the options and change them or use the default options and click Next.
11. I suggest unchecking Use default options, clicking the Options button, and selecting Transfer SQL Server logins (Windows NT and SQL Server logins) before clicking next.
12. Click Next again.
13. Click finish.
14. Do some QA to make certain that nothing was missed.

This question was closed by the author