Post reply

sql to MySql migration

  • April 17, 2008 at 3:01 am

    #93232

    Hi all,

    is there any tool present for the migration of sql procedures to MySql procedures.

    i tried with the MySql's migration tool kit, But it convert only the tables and data but not the procedures.

    any one advice me for the above issue.

    Thanks and Regards,

    N.Prabhakaran

  • April 18, 2008 at 12:09 am

    #804104

    I am not aware of any tool that could convert the stored procs.

    Looking through Google there are some that can convert tables, etc.

    Stored procs only appeared fairly recently in MySQL 5.

    Although both databases are ANSI-something-compliant there are substantial propietary enhancements particularly on the SQL Server side that would make automatic conversion tricky.

    Good luck.

    Peter Lavelle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply