Difference between MySQL and SQL Server
Posted: Tue Jun 06, 2006 11:55 am
Okay.
I do all my web development on a laptop that has Server 2k3 and MySQL 5.
My company has a slew of crappy web sites in (shudder) ASP/VBScript, everyone here loves it - except me.
The thing is that later in the year all of our everything goes in databases on a MS SQL Server. I'm wondering how much code actually needs to be changed when you switch from MySQL to SQL Server. I'm hoping that it is just the functions. I try to write my SQL as portable as possible.
Thanks in advancezor
I do all my web development on a laptop that has Server 2k3 and MySQL 5.
My company has a slew of crappy web sites in (shudder) ASP/VBScript, everyone here loves it - except me.
The thing is that later in the year all of our everything goes in databases on a MS SQL Server. I'm wondering how much code actually needs to be changed when you switch from MySQL to SQL Server. I'm hoping that it is just the functions. I try to write my SQL as portable as possible.
Thanks in advancezor