Dumping Databases

You use the Database Dump utility (DBDUMP.EXE or DBDUMP32.EXE) to extract data from a database into data files called datasets.

When you dump a database, datasets are created from the database, along with a .DCT control file. The control file is saved in a folder you specify, and the datasets are saved in a subfolder of the same folder.

Both the control file and the subfolder where the datasets are saved are named with the ID of the database from which data was extracted.

You can store extracted datasets until you are ready to load them into a different database. For more information, see Loading Databases.

注释：When storing extracted data, you must retain both the control file and the associated subfolder containing the datasets.

To dump a database using the Database Dump screen in Sage 300:

1. 打开 Administrative Services > Database Dump.
2. In the Database field, specify the database from which you want to extract data. (The database list comes from the SharedData entry in the Windows registry.)
3. In the Dataset Directory field, enter the folder where you want to save the extracted datasets.
4. Click Dump.

To dump a database using the Database Dump tool:

1. On the Windows Start menu, click Sage 300 > Tools > Database Dump.
2. Enter your user ID and password, and then click OK.

   The Dump Sage 300 Data screen appears.

3. Select the database from which you want to extract data. (The database list comes from the SharedData entry in the Windows registry.)
4. Click Set Directory.

   The Set Dataset Directory screen appears.

5. Enter the folder where you want to save the extracted datasets, and then click OK.
6. Click Dump.