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

Synchronise tables

User, date Message
Written by alanmcd
7 years ago
Category: General
3 posts since Mon, 16 Jul 07
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
Written by ansgar
7 years ago
4793 posts since Fri, 07 Apr 06
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.)
Written by alanmcd
7 years ago
3 posts since Mon, 16 Jul 07
I don't suppose there's any plans to do a schema comparison is there?
Alan
Written by muzza4
7 years ago
51 posts since Mon, 04 Dec 06
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
Written by ansgar
7 years ago
4793 posts since Fri, 07 Apr 06
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?
Written by alanmcd
7 years ago
3 posts since Mon, 16 Jul 07
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
Written by darkangel
3 years ago
14 posts since Wed, 08 Jul 09
+1

I'd like this feature as well.
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
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.
Written by darkangel
3 years ago
14 posts since Wed, 08 Jul 09
Hi Anse,

That doesn't synchronise the table schema.

_da.
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
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)
Written by Rapid-eraser
3 years ago
34 posts since Wed, 23 Jun 10
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.