File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Synchronization

 
dushantha Rathnayake
Ranch Hand
Posts: 103
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 378
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How about some ETL (Extract Transform Load)? You could give Pentaho Kettle a try.
You will have to spend some time learning it though..
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic