Home > IT Answers > Development > sqlserver 2000 stored procedures
Andy11983
0 pts.
 sqlserver 2000 stored procedures
ColdFusion, MySQL, SQL, SQL Server
Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

Software/Hardware used:
ASKED: April 4, 2005  10:02 AM
UPDATED: April 4, 2005  7:19 PM
RELATED QUESTIONS
Answer Wiki:
Hi, I am not quite sure what you mean exactly with to integrate. Do you have to call the stored procedures or do you have to implament identically one in our MySQL system? First thing should be quite simple. For the second you need to know the exact definitions.
Last Wiki Answer Submitted:  April 4, 2005  10:25 am  by  Hypidia   0 pts.
All Answer Wiki Contributors:  Hypidia   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You want to migrate from SQL Server 2000 to MySQL 5 beta? Or MySQL 4? in V4 there are no stored procedures available…You can try the migration toolkit from MySQL

Mt69
 0 pts.
 

Hi,

Thanks-for your help

Are stored procedures available in mysql V5. The software the we are trying to integrate is an in house application – currently using sql2000 for the stored produres. If it cannot be accomplished it will mean re-writing all of the procedures as .cfm.

Andy11983
 0 pts.
 

Are stored procedures available in mysql V5? Yes, but version 5 is still in beta, and it may be quite a while before it’s stable enough to be released in production status.

r937
 0 pts.