• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Database Synchronization

 
Ranch Hand
Posts: 103
  • 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.
 
Sheriff
Posts: 3838
66
Netbeans IDE Oracle Firefox Browser
  • 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.
 
Ranch Hand
Posts: 378
  • 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..
 
Stop it! You're embarassing me! And you are embarrassing this tiny ad!
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!