Skip to content

This is a program to convert MySQL Stored Procedures (and table creation) to MS SQL TSQL Stored Procedures

Notifications You must be signed in to change notification settings

PrairieTrailDave/MySQL_ToTSQLConverter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

MySQL_ToTSQLConverter

This is a program to convert MySQL Stored Procedures (and table creation) to MS SQL TSQL Stored Procedures

This program was written a decade ago when I had the task of converting 75 stored procedures over to TSQL. At the time, there weren't any such conversion programs. The only conversions I could find were just of the table definitions.

I got this program to the point where it did most of the simple work of converting, some of the formatting, how the if statements needed to be different, etc. It made the remaining manual process much smaller.

This program does not do everything someone non-technical would want it to do. It does not properly convert all the built in function arguments. Nor does it properly handle calling subroutines (other stored procedures).

Basically, it is not a "finished product". I stopped when further work wasn't going to help get the project at hand further. I got the job done. A finished product would not only handle all the built in functions, but would flag places where a simple conversion won't work. Any automatic conversion has limits and humans have to take the converted program to a professional product.

As it was written quite some time ago, it handled MySQL version 5.5.

About

This is a program to convert MySQL Stored Procedures (and table creation) to MS SQL TSQL Stored Procedures

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages