Can Sqlyog Sync With Microsoft Access?

[zzz1563]

Can SQLyog data sync a MySQL database with a Microsoft Access database?

I suspect the answer is “Yes” to my question as there seems to be a lot of people talking about Microsoft Access but no definitive statements.

Here are other questions:

Can SQLyog data sync a Microsoft Access database on one computer and a MySQL database on another computer across the Internet using ODBC?

Can SQLyog sync the database scheme between a Microsoft Access database and a MySQL database? On another computer using ODBC? If not, is there a different protocol it can use?

Can SQLyog recognize when a remote database is available and data sync automatically?

Now for the full story:

My wife carries around a Tablet. It has some form software that connects to an Access database. When she goes on the road each day, she takes the whole database with her. However, I have a need to access the data even when she is on the road. I thought I could use SQLyog to sync the Access database to a MySQL database on a server whenever her computer returns home. That way, my work and her work are “in sync.”

Can I do this with SQLyog?

With what little I've told you, can anyone suggest a better way to setup these databases for access by both of us?

Rob

[peterlaursen]

The SQLyog' Data Sync Tool' will sync between 2 MySQL databases. But the 'Import External Data Tool' will import data from any ODBC source including Access. If the ODBC driver can connect over the Internet then also SQLyog can connect to the ODBC source.

The tool will not detect changes on the ODBC source automatically. It is not a 'listening background process'. You can schedule the task to run at intervals. Please check the resources:

* relevant paragraph in the program help file

* this old but still relevant article: http://www.databasejournal.com/features/my…Lyog-ver-41.htm

* this FAQ: http://www.webyog.com/faq/content/17/79/en…-data-tool.html

* and this FAQ: http://www.webyog.com/faq/content/27/114/e…agent_-sja.html

Please download and install the ENTERPRISE TRIAL. Only you can judge if it is relevant for your needs.

[Author]

Posts