When you click on a particular table "Table options" are displayed in the right panel. Here you can configure options specially for the selected table.
You are able to specify Table engine type: InnoDB, MyISAM, HEAP or BDB. Character set selection is also available.
Here you can choose the following options:
Filter - define filters to retrieve only the specific data that you interest for conversion.
Copy structure - if set, database structure will be copied or modified to the destination database.
If "Copy structure" check box is checked you can choose the options below.
- Copy indexes - if set indexes will be copied
- Copy foreign keys - if set foreign keys will be copied
- Overwrite existing table - if a table being copied already exists, this option specifies whether it will be overwritten.
- Modify existing fields type - (available only if the previous options are not checked) - if you choose this option, type of the fields from
source database will be given to the fields with the same name in destination base (this will cause previous field type to be lost).- Modify existing indexes - (available only if "Overwrite existing fields" option is not checked) - In case an index in source table differs from
an index in destination table the "destination" index will be replaced with the "source" index.- Modify existing foreign keys - (available only if "Overwrite existing fields" option is not checked) - In case a foreign key in source table differs from
a foreign key in destination table the "destination" foreign key will be replaced with the "source" foreign key.Copy data - if set, database data will be copied to the destination database.
If "Copy data" check box is checked you can choose the options below:
Insert sync - If checked "Insert-synchronization" will take place. The program will only add records from a source to a destination
if there are no identical records in the destination base (a synchronization relying only on "insert"-statements).
Update sync - If checked "Update-synchronization" will take place. This "update'-statements based synchronization will replace the altered records.
Drop sync - If checked "Drop-synchronization", the program will only delete records in the destination that have been deleted in the source. All checkboxes are checked by default because these three options allow you to accomplish complex synchronization. In case you don't need some type of synching to be presented uncheck the appropriate checkbox.
