Synchronise tables
| User, date | Message |
|---|---|
|
Written by alanmcd
6 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
6 years ago 3950 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
6 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
6 years ago 50 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
6 years ago 3950 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
6 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
2 years ago 12 posts since Wed, 08 Jul 09 |
+1 I'd like this feature as well. |
|
Written by ansgar
2 years ago 3950 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
2 years ago 12 posts since Wed, 08 Jul 09 |
Hi Anse, That doesn't synchronise the table schema. _da. |
|
Written by ansgar
2 years ago 3950 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
2 years ago 33 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. |