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

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