aspose file tools*
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: 3438
    
  47

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: 347
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
 
Similar Threads
No proxy with session.load() instead it does a database hit - Why?
designing login page
share data
menu creation
Sharing data between web app's