pyxmdb Publisher's description
from Philip Patterson
A free tool to eXport or iMport data from/to a database.
pyxmdb.py is a free tool to eXport or iMport data from/to a database. The project 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).
tar -zxvf pyxmdb.v?.?.tgz
chmod +x pyxmdb.py
Here are some key features of "pyxmdb":
В· import or export from/to a comma delimited text file into/from a MySQL, Oracle, PostgreSQL, Ingres or SQLite database.
В· flexible logging which can be altered via a config file
В· additional DBMS support can be added via a config file (no code changes required)
В· import has support for auto commit after every "x" rows
В· import can abort the process after "x" many errors
В· export can write out a header record as the first row
В· import can skip the first row if it is a header record
В· export will take any valid SQL select statement and write the result to the output file
В· import has some flexibility for mapping fields in the source file to columns in the destination table
В· Has been test on both Linux (FC7) and Windows (XP) with Python 2.4 and 2.5
What's New in This Release:
В· Minor bug fix. During the code cleanup for v0.6 I accidentally broke support for using the "--sqlfile" command line parameter during an export.
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall