Skip to content

Coding-Ninja/mssql-guid-transform

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

Microsoft SQL Server GUID Transformer

The context of this is explanined over at https://www.codingninja.co.uk/the-joys-of-migrating-from-sql-server-to-mariadb/

Usage

First clone down the repo:

$ git clone https://github.com/coding-ninja/mssql-guid-transform
$ cd mssql-guid-transform/

Next just modify the script to add in your MySql connection details as can be found from line 30:

#====================================================
# configuration
#====================================================
DB_HOST = "your_host"
DB_USER = "your_user"
DB_PASS = "your_password"
DB_NAME = "your_db_name"

Now simply run the python script (this is Python 2.7 IIRC):

$ python transform.py

About

A small script used to fix up MSSQL GUIDS to BINARY(16) after migration from MSSQL to MySQL or MariaDB

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages