Moving Databases

The steps for moving a SQL Server database include setting up a new database, then moving the data from the old one to the new one.

The following instructions are for moving a database using the Database/Object Transfer screen in SQL Enterprise Manager. You can also move the database by using the Database Dump and Database Load utilities.

注释：If you are moving the database to a server that has a different sort order or character set, you must use the SQL Transfer Manager. For more information on this procedure, see your SQL Server documentation.

To move a SQL Server database:

Create a new device for the new database location using SQL Enterprise Manager. The new device must be large enough for the database you are moving.
If you are moving the database to another server, make sure that:
- Both servers use the same sort order and character set.
- The syslogins table is the same for both servers. If not, you will have to use aliases to map owners to their objects. Refer to your SQL Server documentation for more information.
Create the new database on the new database device using SQL Enterprise Manager. (Note that the new database name must be unique.)
- The new database must be large enough for the database you are moving.
- Use the Create for Load option when creating the database.
- Do not place the transaction log on a separate device. (See your SQL Server documentation for information on moving the database log.)
From the Tools menu in SQL Enterprise Manager, click Database/Object Transfer.
Specify the source and destination servers and databases, and initiate the transfer.
Create new data sources on each Sage 300 workstation.
Start Database Setup, select the database profile to edit, and click the Edit command.
In the Edit SQL Server Database Profile dialog box, specify the new data source and database name, then click OK.
Leave Database Setup, start Sage 300, and select the company. If the correct data is displayed, delete the original database.