Database Synchronization

[dushantha Rathnayake]

Hi,

I have a Ms Access database and a MySql database. I want to sync tow tables in these databases. How can i do it ?

Thank you.

[Martin Vashko]

dushantha Rathnayake wrote:Hi,

I have a Ms Access database and a MySql database. I want to sync tow tables in these databases. How can i do it ?

Thank you.

To "Sync tables" is quite a broad term. Assuming you're dealing with a MDB database on the Access side, it should be possible to link the MySql tables into the Access database (there is the Link tables functionality, details depend on the version of Access you're using) and handle the situation on the Access side, either with views or other queries, or in the worst case programmatically in VBA.

[Gamini Sirisena]

How about some ETL (Extract Transform Load)? You could give Pentaho Kettle a try.
You will have to spend some time learning it though..