Set-up Migration Options

Understanding Migration options:

• Migrate primary keys – if you select this option, the primary keys defined for the migrated table will also be migrated. If you omit this option, the copy of the table on the target side will not contain primary keys. [Default value – omitted].
• Migrate indexes – if you select this option, the table will be copied with all the indexes definitions. If you omit this option, the copy of the table on the target side will not contain indexes. [Default value – selected].
• Migrate foreign keys – if you select this option, the foreign keys defined for the migrated table will also be migrated. If you omit this option, the copy of the table on the target side will not contain foreign keys. [Default value – omitted].
• Consider Text data as Binary data – if you select this option, Text data will not be saved in Insert SQL statement, but will be inserted into the targeted table using ODBC APIs. It is recommended, when the Target database has Length limitation of SQL statement. If you omit this option, regular SQL statement will be used for data migration. [Default value – omitted].
• Consider Unicode data as Binary data – if you select this option, Unicode data will not be saved in Insert SQL statement, but will be inserted into the targeted table, using ODBC APIs. It is recommended when the Target database has Length limitation of SQL statement. If you omit this option, regular SQL statement will be used for data migration. [Default value – omitted].
• Consider Long Text data as Binary data – if you select this option, Long Text will not be saved in Insert SQL statement, but will be inserted into the targeted table, using ODBC APIs. It is recommended when the Target database has Length limitation of SQL statement. If you omit this option, regular SQL statement will be used for data migration. [Default value – omitted].

• Set-up Comparison options
• Set-up Conversion rules
• Set-up SQL vendor specifics