/oracle2mysql

Simple script to convert tables from Oracle to MySQL

Primary LanguagePython

oracle2mysql

Simple script to convert tables from Oracle to MySQL. This was created for the Schoenberg Database of Manuscripts project.

Installation

You will need to install the following python packages:

MySQLdb 
cx_Oracle

Note that finding the right cx_Oracle package to use with your Oracle installation can be tricky. The SDBM dev environment, running on CentOS 5 and Python 2.6, uses cx_Oracle-5.1.2-10g-py26-1.x86_64.rpm.

Edit the oracle2mysql_conf.py and specify the hostnames, accounts, and passwords for your two databases.

Running the script

python oracle2mysql.py oracle2mysql_conf

For help, run the script without any arguments.