pyxmdb


pyxmdb.py is a free tool to eXport or iMport data from/to a database. It is written in Python (v2.5 and v2.4) and is meant to be as database neutral as possible. Anything that is DBMS specific, is stored in a user editable config file (pyxmdb.py.cfg).

If desired, you could use this to perform the 'E' and 'L' parts of an ETL (Extract, Transform, Load) process. The 'T' could then be performed by any other application or utility of your choice. This easiest way to do this, would be to have one copy of pyxmdb export the data to standard out, pipe the output to something like awk or sed, and then pipe that output to another copy of pyxmdb to import the data.

License: GNU GPL v2

To contribute new/better code, send me an email. My address is in the .py file.

My Freshmeat project page is located here, should you wish to stay updated easily.