Page 1 of 1

Difference between MySQL and SQL Server

Posted: Tue Jun 06, 2006 11:55 am
by daedalus__
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

Posted: Tue Jun 06, 2006 12:04 pm
by feyd

Posted: Tue Jun 06, 2006 12:44 pm
by daedalus__
I only have time to skim through that and it helps.

Just in case, if you are trying to say 'stay with MySQL'. We are getting the SQL Server because we a program called Navision and there are only two database engines compatible with it. One of them being SQL Server.