wood burning stoves 2.0 *
The moose likes JDBC and the fly likes Database Synchronization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database Synchronization" Watch "Database Synchronization" New topic
Author

Database Synchronization

dushantha Rathnayake
Ranch Hand

Joined: Feb 27, 2010
Posts: 103
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 Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3611
    
  60

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
Ranch Hand

Joined: Aug 05, 2008
Posts: 378
How about some ETL (Extract Transform Load)? You could give Pentaho Kettle a try.
You will have to spend some time learning it though..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Synchronization