This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 3606
    
  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: 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..
 
Don't get me started about those stupid light bulbs.
 
subject: Database Synchronization
 
Similar Threads
menu creation
Sharing data between web app's
share data
designing login page
No proxy with session.load() instead it does a database hit - Why?