Saturday, March 05, 2011

Migrating from access database to mysql

Access has a powerful GUI for desiging tables and specifying relationships which Mysql doesnt have, this makes it much easier to do the design, but for production access is not a database of choice which typically is mysql or oracle or MSSQL server, while moving from access to MSSQL is straight forward, its relatively easy to move from access to mysql or oracle too.
create an odbc connection for mysql or oracle as the case may be, then export the tables from access to the odbc (of mysql or oracle), you may need to specify some mappings but thats straight fwd.
Once you have the db to mysql you can get the sql scripts easily.

Web Hosting Cheap PHP Plans Also at For free flags of the world