Convert Sql Server stored procedure into mysql stored procedure

imshally81 · #1 (**permalink**) 03-04-08, 07:51

hi all,

I just migrated from sql server 2000/2005 to mysql..
i want to convert whole db into mysql...
i have lot of stored procedure which are written sqlserver 2000/2005 environement...
i need a tool to convert sql server 2000/2005 stored procedure into mysql stored procedure....

thanks in advance
Sajjad

muralidaran_r · #2 (**permalink**) 03-18-09, 05:13

Hi

There is no tool to convert MSSQL procedures automatically to MySQL. You have to manually convert T-SQL commands with ANSI SQL(MySQL) by rewriting the procedures.

Muralidaran

neeraj_khandelwal · #3 (**permalink**) 03-19-09, 06:24

I have tons of stored procedure in MSSQL and want to migrate data and stored procedure in Mysql.Can someone help me to any tool to migrate data as well as stored procedure.

--Neeraj

r937 · #4 (**permalink**) 03-19-09, 07:49

neeraj, please see post #2 in this thread

neeraj_khandelwal · #5 (**permalink**) 03-20-09, 12:51

Thanks a lot.
Then we have to migrate stored procedure manually?No other way to migrate tons of stored procedures easily.

--Neeraj

healdem · #6 (**permalink**) 03-20-09, 13:00

post #2 still applies

Quote:

There is no tool to convert MSSQL procedures automatically to MySQL. You have to manually convert T-SQL commands with ANSI SQL(MySQL) by rewriting the procedures.

VLDG · #7 (**permalink**) 03-22-09, 17:17

I suppose something like this can exist for MySQL :

Migration from MS-SQL to Firebird

One question : why migrating to MySQL when you can have Firebird or PostgreSQL who have more features ?

chennai schools · #8 (**permalink**) 03-27-09, 08:22

Quote:

Originally Posted by VLDG

One question : why migrating to MySQL when you can have Firebird or PostgreSQL who have more features ?

But MySQL is the cheaper & more reliable DB available for Web applications...

VLDG · #9 (**permalink**) 03-27-09, 13:11

cheaper : one of the cheaper :P

where do you see : it is for web...

he want this

Quote:

i have lot of stored procedure which are written sqlserver 2000/2005 environement...
i need a tool to convert sql server 2000/2005 stored procedure into mysql stored procedure....

r937 · #10 (**permalink**) 03-27-09, 13:28

VLDG : where do you see "i want firebird" ???

he want this : mysql

VLDG · #11 (**permalink**) 03-27-09, 13:37

So, I hope he don't use too many features in MS SQL like CTE, good backup and many more...

If he will use PostgreSQL or Firebird : he can convert more things.

r937 · #12 (**permalink**) 03-27-09, 13:58

Quote:

Originally Posted by VLDG

If he will use PostgreSQL or Firebird : he can convert more things.

so what?

if he left it as mssql, he wouldn't have to convert anything

the point is, he said he wants mysql

tossing in your advertisement for something else is not helpful

girishkardam · #13 (**permalink**) 03-28-09, 01:43

Hi Neeraj,

If ur not hvg any problem in sharing ur database with me than I can help u in the migration.

muralidaran_r · #14 (**permalink**) 04-09-09, 01:46

Hi

I am using SQLWAYS tool for evaluation purpose to convert all my SPs. Its working amazingly.

http://www.ispirer.com/download/sqlways391905.zip

Wish you all the best

Muralidaran