Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: Migration from MSSQL to MySQL

    Hi,

    We have an application based on ASP-SQL SERVER. Now, the client wants this to be changed to MySQL.

    In our present application we have used SQL Stored Procedure extensively.

    I have few questions:

    1. How difficult is the migration?
    2. Can we create Stored Procedure in MySQL? If not, what is the equivalent in mySQL?
    3. Can you suggest some ways by which the ASP coding (changing) can be minimized?

    Thanks for reading.

    Rahuul

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    1. How difficult is the migration?

    there should be no problem converting the tables

    all the queries have to be checked


    2. Can we create Stored Procedure in MySQL? If not, what is the equivalent in mySQL?

    stored procs are only in version 5, which is still in beta test mode

    there is no equivalent


    3. Can you suggest some ways by which the ASP coding (changing) can be minimized?

    have somebody read every piece of code and look for the queries

    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
  •