Features:
- converts CREATE PROCEDURE/FUNCTION syntax
- adds semi-colon at the end of statements
- converts IF and WHILE statements to MySQL syntax
- sorts the code in the correct order, with declarations at the top and instructions
- after that
- removes @, [ and ] from identifiers
- converts comments to MySQL syntax (a space in the 3rd position for -- comments)
- adds a CONTINUE HANDLER FOR NOT FOUND if the procedure contains cursors
- comments out GOTO and labels (you will have to restructure this yourself, since there is no GOTO in MySQL stored procedures)
- converts some data types (nvarchar, identity, smalldatetime, money, smallmoney)
- Converts function with a direct MySQL correspondence (getdate, getutcdate, len, replicate)
- No conversion of GOTO:s and labels
- no MySQL error handling added
4 comments:
how to execute the .exe file.For example if I have a .sql file please tell me the steps I should follow to convert it to mysql.
I will add somewhat yet
Strings:
[T-SQL] "a" + "b" + "c"
[MySQL] concat("a", "b", "c")
Dates:
[T-SQL] getdate() - 2
[MySQL] date_add(now(), interval -2 day)
[T-SQL] datepart(weekday,date)
[MySQL] DAYOFWEEK(date)
Post a Comment