Migrating from Access tables to MySQL tables automatically

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Migrating from Access tables to MySQL tables automatically

Post by alex.barylski »

I'm building a new system very soon to replace and old Access applicatoin for repair procedures program. Hundreds of tables. :)

My concern is that, because we are using a JS library for the interface, that one little data error could stop the system from being usable. Ideally I build some migration scripts to allow the old system to take over in case of emergency, until the new system error has been resolved.

To complicate matters, there are two separate Access databases in geographically different places. One here and the other in the States somewhere.

Basically I need a way to automatically merge the changes made to Access database 1 and 2 then merge those changes into the web based MySQL tables (which are going to have potentially different schema).

Are their any tools which I might use to expedite this process and maybe automate. SQLyog apparently has a tool which allows DB differencing between two MySQL tables.

Any tools?

Cheers,
Alex
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Migrating from Access tables to MySQL tables automatically

Post by josh »

Why would there be "one little data error" and why would you deploy the system before testing it? I would have your synchronization scripts run an automated test suite and take snapshots of the database should it need to rollback in response to a test failure. Then it would ideally email a developer who would fix it before the data got too out of date.
Post Reply