When a full repository migration is not needed, which is very likely the case in test situations, we can use the Export Repository and Import Repository procedures provided by the Database Server Utilities. The invocation of these procedures is similar to the process described in the previous section.

Both procedures simply invoke the repimexp command line utility and pass the parameters entered using the Configuration Wizard. The repimexp utility can also be used manually, for example to export and import repositories from and to local developer databases.

The result of the export procedure is a flat file with a .dat suffix. This file contains all repository data. We can then use the import procedure to load the file's content into a target Siebel database. The import result is a new repository in the target database.

The following procedure describes how to use the repimexp command line utility to export a repository into a flat file: