Set the following properties of the DBCopier:
Property | Description |
|---|---|
| The |
| The |
| A comma-separated list of the names of the tables in the |
| The name of a scratch directory for SQL and data files used during the copy operation. This directory must exist before the copy is launched. It is strongly recommended that no other processes or facilities use this scratch directory, especially other |
| Set this to true to delete the files in the scratch directory after the copy is performed. Defaults to |
In addition to the above properties, which are common to all DBCopier classes, each of the DBCopier subclasses has the following properties you may need to configure.
BcpDBCopier
This DBCopier for MSSQL databases uses the bcp utility for copy data. Generally, you can use this copier with the default property settings, with one exception. You should set the BcpDBCopier’s maxTextOrImageSize property to a value no smaller than the largest text or image column in the tables being copied. See your Microsoft documentation for details.
DB2DBCopier
This DBCopier for DB2 databases uses the DB2 export and import utilities. If you are running the DB2DBCopier on UNIX or any other operating system that uses “/” as a directory separator, set the useUnixStyleDir property of the DB2DBCopier component to true. If “\” is the directory separator, set the useUnixStyleDir to false. The DB2 export utility wants to store binary objects in their own files, so make sure that the directory property points to a location in which these files can be stored temporarily. See your DB2 documentation for details.
OracleDBCopier
This class is a DBCopier for Oracle databases. This copier uses the Oracle exp and imp utilities. You can configure OracleDBCopier to use direct path for exporting. To enable direct path for exporting, set the useDirectPathForExport property of the OracleDBCopier to true. This property is false by default.
See your Oracle documentation for more information on using direct path with the exp utility.
