If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Convert Sql Server stored procedure into mysql stored procedure

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-04-08, 07:51
imshally81 imshally81 is offline
Registered User
 
Join Date: Feb 2005
Posts: 36
Convert Sql Server stored procedure into mysql stored procedure

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
__________________
Regards,
Sajjad
C U ON NET
reply me : sajjaddotnet@yahoo.com
Reply With Quote
  #2 (permalink)  
Old 03-18-09, 05:13
muralidaran_r muralidaran_r is offline
Registered User
 
Join Date: Sep 2007
Location: India
Posts: 21
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
Reply With Quote
  #3 (permalink)  
Old 03-19-09, 06:24
neeraj_khandelwal neeraj_khandelwal is offline
Registered User
 
Join Date: Jan 2009
Posts: 5
convert sql server stored procedure into mysql stored procedure

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
Reply With Quote
  #4 (permalink)  
Old 03-19-09, 07:49
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
neeraj, please see post #2 in this thread
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 03-20-09, 12:51
neeraj_khandelwal neeraj_khandelwal is offline
Registered User
 
Join Date: Jan 2009
Posts: 5
Thanks a lot.
Then we have to migrate stored procedure manually?No other way to migrate tons of stored procedures easily.

--Neeraj
Reply With Quote
  #6 (permalink)  
Old 03-20-09, 13:00
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,262
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.
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #7 (permalink)  
Old 03-22-09, 17:17
VLDG VLDG is offline
Registered User
 
Join Date: Mar 2009
Posts: 24
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 ?
Reply With Quote
  #8 (permalink)  
Old 03-27-09, 08:22
chennai schools chennai schools is offline
Registered User
 
Join Date: Mar 2009
Posts: 2
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...
Reply With Quote
  #9 (permalink)  
Old 03-27-09, 13:11
VLDG VLDG is offline
Registered User
 
Join Date: Mar 2009
Posts: 24
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....
Reply With Quote
  #10 (permalink)  
Old 03-27-09, 13:28
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
VLDG : where do you see "i want firebird" ???

he want this : mysql

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #11 (permalink)  
Old 03-27-09, 13:37
VLDG VLDG is offline
Registered User
 
Join Date: Mar 2009
Posts: 24
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.
Reply With Quote
  #12 (permalink)  
Old 03-27-09, 13:58
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #13 (permalink)  
Old 03-28-09, 01:43
girishkardam girishkardam is offline
Registered User
 
Join Date: Mar 2009
Posts: 5
Hi Neeraj,

If ur not hvg any problem in sharing ur database with me than I can help u in the migration.
Reply With Quote
  #14 (permalink)  
Old 04-09-09, 01:46
muralidaran_r muralidaran_r is offline
Registered User
 
Join Date: Sep 2007
Location: India
Posts: 21
MSSQL to MYSQL

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

Last edited by muralidaran_r; 04-09-09 at 03:00.
Reply With Quote
  #15 (permalink)  
Old 04-09-09, 07:36
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
Quote:
Originally Posted by muralidaran_r
I am using SQLWAYS tool for evaluation purpose to convert all my SPs. Its working amazingly.
thank you for the update, i was not aware of this tool

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On