Using ASP(.NET) with MySQL Migrating to MS SQL

[iknowkungfu]

Apologies if this is a really dumb question but:

I need to build a website in ASP/ASP.NET. I'm not sure which my client has
It will be connected to a database, either MS SQL or MySQL, again I don't know which.

For development I want to get a webhost and it's much easier to get ones with ASP.NET and MySQL.

1) Can I do ASP development on host which advertises as ASP.NET server?
2) How different will the ASP/.NET code be for MS SQL and MySQL? - Can I abstract the differences somehow?
3) How difficult would it be to convert a MySQL database to MS SQL (or vice versa)?

Specifically, I was looking at NetPivotal

Any help is greatly appreciated,
J

 

[iknowkungfu]

Gizmo,

Thanks for that, I've looked through a couple of the slides on that page, even if it's not what you hoped it was!

I'm not too worried about MySQL / MS SQL, what I'm more concerned about now is programming in ASP. Can I do that on an ASP.NET server?

I know it means writing more/complex code, but I need to start work on this asap so if I can just write ASP and have it run on ASP server or ASP.NET server (whichever my client has), then I can get going.

Cheers,
J

 

[dan-cat]

The netpivots link you posted supports both asp and asp.net 1.1 and 2.0 so you should be fine with them. Though you've probably already made your decision by now