Wednesday, February 13, 2013

MySQL to Microsoft Access Database Migration

A couple weeks ago, my colleague wanted to migrate a database supporting the Project Management Body of Knowledge (PMBOK) from MySQL to Microsoft Access, in response to requests from MetaTeam Blog readers.

Create table statements already existed and were easily run in Access. DatabaseSpy performed a critical database schema comparison to verify the new table structures and relationships. Then, a DatabaseSpy database contents compare and merge moved hundreds of rows of data into the 11 tables. DatabaseSpy resolved all the differences between SQL dialects and datatypes of MySQL and Microsoft Access and completed the task in seconds.

Of course, you could just as easily go the other direction to migrate an organically grown Access database to MySQL or another enterprise-grade database.

Database tables in a DatabaseSpy Design window

You can read the details in A Relational PMP Study Aid, Part 2 on the MetaTeam Blog.

Part 1, titled A Relational PMP Study Aid, describes how candidates can use the PMBOK to prepare for Project Management Professional (PMP) certification.

Altova MetaTeam is the online project management and collaboration environment for teams that want to achieve high performance results by working smarter. If you haven’t seen it yet, you can check out a 2-minute MetaTeam video introduction here.

No comments: