GitHub - Nick011/MSSQL-to-MySQL: A python script to basically copy a MSSQL database and paste it as a MySQL database.

Nick011 / MSSQL-to-MySQL Public

Notifications You must be signed in to change notification settings
Fork 23
Star 35

A python script to basically copy a MSSQL database and paste it as a MySQL database.

35 stars 23 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
README		README
convert_db.py		convert_db.py
sqlserver_datatypes.txt		sqlserver_datatypes.txt

Repository files navigation

MSSQL-to-MySQL is a quick and dirty python script for cloning a MSSQL database to MySQL.
The script executes well enough for my needs, but could be greatly improved by supporting all necessary data type conversions from MSSQL to MySQL, as MySQL doesn't support all the types provided by MSSQL.


Requirements:
- Python 2.6 or higher
- MySQLdb (easy_install mysql-python)
- pyodbc (http://code.google.com/p/pyodbc/)
- FreeTDS (http://www.freetds.org/)*

*FreeTDS may require additional configuration beyond installation. I had to modify /etc/odbc.ini and odbcinst.ini to point at my FreeTDS installation.

Instructions:
- Install above requirements.
- Modify the convert_db.py script to include the connection information for your source MSSQL database and your destination MySQL database.
- Upload convert_db.py to your server and run it. If you don't receive an error, the conversion was successful, congratulations!
If you do receive an error, start de-bugging and fork your changes or submit a pull request.