When you click on Tables you can configure "Tables options" displayed in the right panel.
Tables Options available here will be applied to all the tables contained in the database.
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
- Copy foreign keys - if set foreign keys 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.- 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.
