Hi there,

I am converting a database from MS-Sql to My-SQL. (My application is an ASP website)

The MS-SQL database currently makes extensive use of views.

From what I understand, My-SQL currently doesn't support views. This obviously makes my conversion process very difficult.

Someone suggested to me that I should investigate using Stored Procedures as opposed to views.

a) Does MySQL support Stored Procedures ?

b) Would it be possible to use Stored Procedures instead of Views ?

c) If positive, would it mean major code changes to my ASP site to accomodate this ?

Thanks for the help!

Cheers

Steve

A) Not yet
B) Not yet
C) Probably

-PatP

Hi Steve!

You should remember: a view is actually a predefined, stores SQL-query and whenever you make a new query against a view, the DBMS first merges these two queries. Now MySQL does't support this feature, so you had to by hand. It's a big job, but can be done.

Cheers, Bill