distal-attribute
distal-attribute
distal-attribute
distal-attribute

Synchronise tables

alanmcd posted 7 years ago in General
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
ansgar posted 7 years ago
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.)
alanmcd posted 7 years ago
I don't suppose there's any plans to do a schema comparison is there?
Alan
muzza4 posted 7 years ago
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
ansgar posted 7 years ago
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?

alanmcd posted 7 years ago
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
darkangel posted 4 years ago
+1

I'd like this feature as well.
ansgar posted 4 years ago
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.
darkangel posted 4 years ago
Hi Anse,

That doesn't synchronise the table schema.

_da.
ansgar posted 4 years ago
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)

Rapid-eraser posted 4 years ago
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.

Please login to leave a reply, or register at first.