Online Documentation

Table settings

For ultimate control over conversion process, you can alter the way conversion is made to the level of each column. For now, you can't change, remove or add key or constraint definitions.

The following image shows the interface.

table-settings

You can alter

•	Table name

•	Column name

•	Column type, including nullability, default values etc. - as you can directly override column definition for create table statement

You can even

•	Skip certain columns

•	Reorder columns in target table

•	Add new columns (which do not exist in source table) and even automatically set them to a value or expression result during conversion

•	Skip indexes and/or constraints

•	Use special field value {%ROW%} which translates to row number, starting with 1. Especially useful when you want to autogenerate primary key values.