Re: Converting various DB's to MySQL using PHP

On Friday 03 October 2003 11:41, J Morton wrote: > Summary: Using PHP, need to go from ACCESS -> MySQL. (Millions of > records, hundreds of tables.) > > I am about to embark on a project over the next week which entails (in > part) developing a PHP platform that will convert an Access DB to MySQL, > as well as perform all needed error-checking and appropriate field-type > setup. In the future I will modify the same script to support other DB > types like Postgres, MS, Oracle, etc. Rather than having PHP access > these foreign DB types I will have it access a delimited text output of > the DB's. "Foreign" DB types? What are the "native" DB types then? > Before I got started, I thought I would check in here to see if anybody > knows of a similar tool that already exists.... Not sure what you're trying to ask here. Upstairs you say that PHP is going to access the data via delimited text files, which presumably the DBMS in question is able to export. PHP has functions to import said text files, thus no other tools are necessary? > and perhaps I can learn > something from it and benchmark against it as I proceed. Also, any tips > or advice would be muchly appreciated. I am sure this has been done > many times over in PHP but I do not see where. I know for a fact that there are plenty of (at least one) MS-Access to MySQL tools out there (though not necessarily PHP-related). -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* Banectomy, n.: The removal of bruises on a banana. -- Rich Hall, "Sniglets" */