Yes, you'll need to change quite a lot, but I can't help you with it much as I don't know ASP or MSSQL. Microsoft SQL is a Windows only software and cannot be installed on our Linux servers, nothing can be done about that.
Although they do the same thing, MySQL and MSSQL are two seperate pieces of software and work very differently.
-Luke.