Page 1 of 1

Migrating from Access tables to MySQL tables automatically

Posted: Mon Dec 14, 2009 1:09 pm
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

Re: Migrating from Access tables to MySQL tables automatically

Posted: Tue Dec 15, 2009 6:22 am
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.