Unexpectedly, the converter is actually complete. It has a full range of options for Postgre, MySQL and Microsoft Access. Currently, only table dump conversion is possible, query to query conversion is coming soon. Please read the instructions on how to prepare and obtain a suitable table dump for correct conversion into useful queries of your choice.

 

Give it a try . 

 

In the next few days the converter will be packaged up into an installable set of scripts that you can use on your own server. Eventually (when its working sufficiently) all of these scripts will be made Open Source. There will be a press release made available when this happens.

The script to automatically convert a table dump from Microsoft Access to an update / insert query for MySQL is nearly complete for general use. It will be uploaded by tomorrow very soon for use. The script itself takes a text file dump of table data and converts the file into a list of queries to update a matching table in a MySQL database. All you need to do is make sure that the fields in both tables are the same for where you want them to be, they dont even need to be the same column names. Full instructions on exporting the data into a correctly formatted tables.txt file will be included.

 

Once this is complete it will not be long before the same thing is released for MySQL to Access, and soon after the Postgre scripts will follow.If you have any questions or suggestions then please contact me .

As is obvious, the site has been seriously modified. The CMS that was being used just wasnt cuting it for what was required, so it has been replaced with Joomla. This has very little effect on the SQL Converter project, but it will make things run a little smoother through better presentation.