Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: 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

  2. #2
    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

  3. #3
    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

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    neeraj, please see post #2 in this thread
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    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

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    post #2 still applies

    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 on the Tiger 800 or the Norton

  7. #7
    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 ?

  8. #8
    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...

  9. #9
    Join Date
    Mar 2009
    Posts
    24
    cheaper : one of the cheaper :P

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

    he want this
    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....

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    VLDG : where do you see "i want firebird" ???

    he want this : mysql

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    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.

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    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.

  14. #14
    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 04:00.

  15. #15
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •