Transferring the Project s Database to a Server

Transferring the Project's Database to a Server

Access 2002 adds two new choices to the ADP Tools, Database Utilities menu Transfer Database and Copy Database File. The Transfer Database choice uses SQL Server 2000's Data Transformation Service to create a copy of the current database on another machine running SQL Server. The most common use for this utility is to place a database you've developed into production on a workgroup server. Transfer Database is a live copying process; you don't need to disconnect from the current database.

To copy your project's database to a server, do the following:

1. Choose Tools, Database Utilities, Transfer Database to open the Transfer Database Dialog.

2. Select the destination server OAKMONT-DC1 for this example in the drop-down list (see Figure 20.40).

   Figure 20.40. Specify the target server for the current database in Transfer Database dialog.

   

3. If you're transferring the database to a Windows 98/Me machine, you must specify a username and password for SQL Server security. (A password is required only if you've secured the sa account.) Otherwise, accept the default integrated Windows security.

4. Click Next and then Finish to start the transfer process, which displays a progress dialog (see Figure 20.41).

   Figure 20.41. This progress dialog displays each step in the Transfer Database operation.

   

5. When the transfer process completes, your project remains connected to the local (original) database.

The Copy Database File choice copies the database files to the location you specify. When you make this choice, the message shown in Figure 20.42 opens. If you click OK, the Open dialog appears to let you make a copy of the SQL Server database (.mdf) file in another location that you can attach to SQL Server.

Figure 20.42. Before you can copy the project's database file to another location, you must close all connections to the database.