Slashdot Mirror
Transferring Data 'Tween Databases
Sysbotz writes "A common request our company gets is how to get data from Access, Paradox, or some other database format and transfer it to a MySQL database. Well we have written a article on how to do this. W accomplish this task by writing a PHP script to read a database file through ODBC and then to construct a SQL file of the data that can then be read into MySQL. I think some slashdotters would like this."
No, it is not worthy of a /. article in my opinion (but my opinion doesn't matter as I'm not in @slashdot.org.corp), this is just a lame script.
No new techniques and code that almost any person with a day of PHP experience would have already written. The only reason I checked it out was that I wanted to see if they figured out how to grab column names or tables names via ODBC. I'd love to be able to grab meta-data about the databases themselves. If this isn't part of the SQL ANSI standard...
You could give me a hand with this if you want. (a C++ library for reading access databases).
The projects been dormant for a while, (work makes my head hurt too much for real development)
thank God the internet isn't a human right.
Java would have been a much better language if you wanted the project to be reusable. JDBC means that we have the same code for every type of DB's. So you could have a 'read all from DB' set of code and a 'write all to DB' set of code, then simply plug the two DB's into an XML config file, and voila, you have exactly what is needed for any type of DB with JDBC drivers (which is everything except the extremely rare and extremely obscure).
That is something worth writing an article about. Not just one very specific case.
Good quote, too many chars. Seriously, the slashdot 120 char limit sucks!