About Database Utilities

Sage 300 includes the following database utilities:

注释:
  • 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.