MySQL to MSSQL

I am going from PHP/MySQL development to ASP.NET/MSSQL development. What differences can I expect to run into between MySQL and MSSQL? Are there any decent online references and tutorials for MSSQL (this forum is the best resource I've found so far)? Is there a web based MSSQL administration tool you would recommend (I've looked into ASPEnterpriseManager and a few others - nothing seems to compare to phpMyAdmin).

Thanks.

"What differences can I expect to run into between MySQL and MSSQL?"

tons -- see Comparison of different SQL implementations


"Are there any decent online references and tutorials for MSSQL?"

you mean, besides the entire documentation manual, SQL Server Books Online?


"Is there a web based MSSQL administration tool you would recommend?"

Enterprise Manager, although it's hardly web-based, it's what you should be using on your desktop before porting your data to your host

Thank you for the reply, r937.

I am using the MSDE engine (I can't afford MSSQL server) to learn with and use - so I do not have the documentation manual.

I will see if I can find Enterprise Manager. Time to go search all through the MS site again

you do so have the documentation manual

i gave it to you

there's also an offline version you can download, it's 300megs

if MSDE is on your desktop, use WinSQL

http://www.microsoft.com/downloads/...&displaylang=en

SQL Server web data administrator!!!!

interesting

where does it run?

let's say my database is on a shared host and they don't allow anything like that installed