Converting MSAccess to MySQL and making ready for SEPA

One of our clients has decided to move a large MSAccess database over to a MySQL solution.

There are tables with the clients profiles, addresses, subscriptions, orders and bank details.

The end result will also have to be capable of producing a XML file for the Single Euro Payments Area (SEPA) for the bank transfers.

Preparing for CakePHP

We’ve decided to use CakePHP 3.2 for a fast start to the new MVC program.

After exporting the the MSAccess tables using a great converting tool “Bullzip MS Access to MySQL” and then importing them into the MySQL database.

There was a lot of junk in some of the tables which had to be patched and cleaned. We renamed the tables, columns and modified the structures to respect the naming conventions of CakePHP before baking everything together.

The SEPA xml

We’ll be using some cool PHP functions and a sepa_access_pain_008_001_02.xsl for the final formatting of our data to the SEPA standard.