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.
SolidDBCopier
This class is a DBCopier
for SOLID databases. You should not need to change any configuration settings on the SolidDBCopier
, other than the SQL environment, connection information, and the database and table names.