Migrating from Access tables to MySQL tables automatically
Posted: Mon Dec 14, 2009 1:09 pm
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
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