Import Command Syntax Examples

Import Command Syntax Examples

Example 1:
diet -import data.dat

The system will insert the data.dat file contents into the database.
Example 2:
diet –objid –import data.dat

The system will store and use objids as unique keys and insert the data.dat file contents into the database.
Example 3:
diet –import new.dat –insert_only –no_recovery

This command line will help to speed up the import of a pristine database. The –insert_only parameter tells the system to only insert new rows into the database without updating or deleting data, and the –no_recovery parameter tells the system to not create recovery files.

Another way to speed up initial imports is to remove the database indexes and reinstate them after the run. However, this will slow down ArchiveManager purge runs and the database for general use.

See Also

Import Command Syntax

Import Command Parameters

Next

Export Command Syntax

Import Command Syntax Examples

Did this topic help you? Email us your feedback.
Last updated: 11/6/2007 12:20:03 PM
© by Dovetail Software, Inc.