Synchronise tables

In the feature set, you mention the ability to synchronise tables between 2 databases.
Do you mean synching the table schema? or table data?
Either way, where is this option in the menu?
or do you do it via export/import etc (data only)?
thanks
Alan

Synchronisation can be done via the dialog "Export tables as SQL". You can either chose another database or another host as target and then select the actions you would like to perform ("Update existing data" etc.)

I don't suppose there's any plans to do a schema comparison is there?
Alan

Hi Anse,

Let me just back up what Alan said above: a schema comparison tool would be great.

At the moment when we upgrade our application I have to dump live and test layouts to file and then do a file compare of the results. It's slow and prone to error and I have to document the differences for the developers.

Cheers
Muzza

Sorry, I'm not sure what you mean by "schema comparison". Maybe this:
- host A has a DB with some tables
- host B has the same DB, but is out of date
- the tool to be created should update host B's DB to the same structure as host A, without touching any records.

Correct?

correct.
the result of the operation would be a list of alter table statements, table creation statements, etc focused on the target databse.
Use Source and Target as the defining words (popular use).
Alan

+1

I'd like this feature as well.

Well this post is super old. Probably the export dialog already helps a bit: Just select the target server + db, plus select table creation/dropping.

Hi Anse,

That doesn't synchronise the table schema.

_da.

Yes, that's why I wrote it helps a bit. However, is there a chance to recreate the tables in combination with INSERT data? (drop + create)

I wouldn't mind for an extra feat but I think if Alter tab did bit clear (or some how move to history) after save, would solve most problems.

When syncing tables between developer and live server is where the problem resides. Since after committing changes locally Alter tab clears, it's some how more difficult to save changes to remote server.