Data Sync with Navicat...

Has anyone been able to successfully Data Sync with Navicat v8.x from live server to localhost (vise versa)?

It seems to be a primary key issue. I’ve tried skipping this table, but subsequently it errors on the next table without a Primary Key. Anyone have any better solutions or how to work around this!

[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_keyword_xref -> localhost.modx_962.modx_keyword_xref
[Err] [Dsy] 1 table [modx_keyword_xref] without primary key
[Msg] [Dsy] Syn Failed 1

Full Navicat error message log:

[Msg] [Dsy] Time elapsed: 0.282s
[Msg] [Dsy] Syn Success
[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_categories -> localhost.modx_962.modx_categories
[Msg] [Dsy] 1: Target Inserted
[Msg] [Dsy] 10: Target Inserted
[Msg] [Dsy] 2: Target Inserted
[Msg] [Dsy] 3: Target Inserted
[Msg] [Dsy] 4: Target Inserted
[Msg] [Dsy] 5: Target Inserted
[Msg] [Dsy] 6: Target Inserted
[Msg] [Dsy] 7: Target Inserted
[Msg] [Dsy] 8: Target Inserted
[Msg] [Dsy] 9: Target Inserted
[Msg] [Dsy] total 10, equal 0, insert 10, update 0, delete 0
[Msg] [Dsy] Time elapsed: 1.390s
[Msg] [Dsy] Syn Success
[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_document_groups -> localhost.modx_962.modx_document_groups
[Msg] [Dsy] 1: Target Inserted
[Msg] [Dsy] total 1, equal 0, insert 1, update 0, delete 0
[Msg] [Dsy] Time elapsed: 0.344s
[Msg] [Dsy] Syn Success
[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_documentgroup_names -> localhost.modx_962.modx_documentgroup_names
[Msg] [Dsy] 1: Target Inserted
[Msg] [Dsy] total 1, equal 0, insert 1, update 0, delete 0
[Msg] [Dsy] Time elapsed: 0.391s
[Msg] [Dsy] Syn Success
[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_event_log -> localhost.modx_962.modx_event_log
[Msg] [Dsy] 1: Target Deleted
[Msg] [Dsy] total 1, equal 0, insert 0, update 0, delete 1
[Msg] [Dsy] Time elapsed: 0.234s
[Msg] [Dsy] Syn Success
[Msg] [Dsy] Synchronize table: live.server.username_modx962.modx_keyword_xref -> localhost.modx_962.modx_keyword_xref
[Err] [Dsy] 1 table [modx_keyword_xref] without primary key
[Msg] [Dsy] Syn Failed 1
[Msg] [Dsy] Finished - Unsuccessfully
[Msg] [Dsy] ROLLBACK
[Msg] [Dsy] ROLLBACK
--------------------------------------------------

To answer my own question. I tried SQLyog trial and it worked. Had to Clear Cache on the online version to see the change but that’s because the page is set to ’Cacheable’. But it means I can work offline <-> online until Revolution is released which is including a data sync option or at least thats what I read in the bugzilla.

Still errors on the tables with no Primary Key, nevertheless data sync worked like I hoped.

WARNING: table `modx_site_plugin_events` does not have a Primary Key or a Unique Key with columns defined NOT NULL. Data Sync will operate in a special mode. Refer to documentation for details. 0 0 0

Did you look at EMS?

http://www.sqlmanager.net/en/products/mysql/dbcomparer

@BobRay, no haven’t heard of that app, but I’ll take a look!