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.
Here you can choose the following options: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
- Overwrite existing tables - if a table being copied already exists, this option specifies whether it will be overwritten.
Example:
In source base we have fields named Table1, Table2 and Table3.
In destination base we have fields named Table1, Table3 and Table4.
In case you choose "Overwrite existing tables" option the tables in destination base named Table1 and Table3 will be deleted and replaced
with tables from source base named Table1 and Table3. Table4 will remain untouched.- Overwrite existing fields - (available only if the previous option is not checked) - if set a field being copied already exists, this option
specifies whether it will be overwritten (this will cause all data in it to be lost as because data from the destination will be deleted and
data from the source will be inserted).- 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).Copy data - if set, database data will be copied to the destination database.
