About Database Utilities
Sage 300 includes the following database utilities:
- Database Dump (DBDUMP.EXE or DBDUMP32.EXE)
- Database Load (DBLOAD.EXE or DBLOAD32.EXE)
- Database Copy (DBCOPY.EXE)
注释:
- No one else can use Sage 300 while these utilities are in use.
- If security is turned on for your Sage 300 system, users must have security authorization to use these utilities. For more information, see Administrative Services Security Authorizations.
Database Dump
Use this utility to extract data from a Sage 300 database. The data can then be stored or loaded into a Sage 300 database.
Database Load
Use this utility to load a dataset (extracted data) into a Sage 300 database.
注释:
- Any data already in the target database will be deleted.
- Before using Database Load, you must create the target database and register it for use in the Sage 300 Database Setup program.
- If you want to load the Sage 300 sample data into your databases, during installation you must select the Data Files For Database Load option on the Select Features screen.
Database Copy
Use this utility to copy the contents of one database to another database without creating an interim extracted dataset.
注释:
- Any data already in the target database will be deleted.
- Before using Database Copy, you must create the target database and register it for use in the Sage 300 Database Setup program.
- You can change a database's ID by copying it to a new database with the desired database ID and then deleting the original database.
提示:Database Dump and Database Load provide convenient formats for storing database backups (because the extracted data format is smaller than a full database) or for copying a database from one system to another.