Skip to content

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

Notifications You must be signed in to change notification settings

fstinner/MSSQL-to-MySQL

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

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.

About

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

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%