how hard would it be and how much code would i have to change to convert to MYSQL instead of sql server 2000 used in the book. I know changability is one of the advantages of this 3 tier structure stuff.

rrr

__________________
rrr

Hello,

I don't have the book, so I don't know what the SQL scripts look like. I've also never used MySQL before, but if stored procedures are involved, then the T-SQL code in those stored procedure won't be supported. Also, I don't know if MySQL will support the collation statements that it appends for character fields when exported as a SQL string; however, that would be easy enough to strip out.

Brian

because i notice most hosting services seem to support MYSQL. So i will only be making changes to the stored procedures?? or is it better for me to just find a host that will support MS-SQL?? if so any recommendations??

rrr

It would be a LOT of work to change it to use MySQL. There are lots of low-cost hosting companies now that support ASP.NET and SQL Server. I'm using 1planhost.com, but I also like easerve.com, and DiscountASP.com. There are many others.
  For learning purposes, you can get a free account at WebMatrixHosting.net - despite their name, they support both Web Matrix and Visual Studio. Although they're in Europe, lots of people in the US use them. They're pretty fast, free, and sponsored by Microsoft.

Eric

Hello,

Most of the sites I saw charged an extra fee for SQL Server support. I would recommend keep using MSSQL if possible, but it depends on your budget and/or your desire to recode the tables/databases.

It will require some effort.

Brian

The problem you will face is that stored procedures are only supported in MySQL 5.0 and upwards. This is not yet a full release and still in the alpha stage.

You can download 5.x and create stored procedures but I don't think you would find many (if any) sites which host on verison 5.

Also the stored procedure implementation on MySQL differs greatly from T-SQL, it's likely you could convert some of the procedures but there are things you can't do in MySQL which are trivial in T-SQL.

For an introduction to MySQL stored procedures check out my site. http://www.mysqldevelopment.com

Andrew Gilfrin