Difference between MySQL and SQL Server

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Difference between MySQL and SQL Server

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Post 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.
Post Reply