Transferring the Project's Database to a ServerAccess 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:
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.
|