« previous next »
Pages: [1]

Author Topic: MYSQL vs MSSQL  (Read 798 times)

0 Members and 1 Guest are viewing this topic.

Offline ejabonetaTopic starter

  • Enthusiast
  • Posts: 162
    • View Profile
MYSQL vs MSSQL
« on: September 08, 2010, 02:38:32 PM »
Just a quick question. I've only worked with mysql but will soon be starting a mssql project. When programming in PHP, anything I should know that's different from mysql? I tried googling but I only got results on performance comparisons, advantages and disadvantages etc. Nothing on actually programming for them.
Logged

Offline Brian Swan

  • Irregular
  • Posts: 47
    • View Profile
Re: MYSQL vs MSSQL
« Reply #1 on: September 30, 2010, 06:50:55 PM »
On the off chance that you are running PHP on Windows, I'd suggest that you use the sqlsrv driver, available here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05. It is released and supported by Microsoft. This wiki entry might be a good resource for getting started: http://social.technet.microsoft.com/wiki/contents/articles/whitepaper-accessing-sql-server-databases-from-php.aspx. Please add to the article if you have helpful input.

Hope that helps.

-Brian
Logged

Offline roopurt18

  • Guru
  • Fanatic
  • *
  • Posts: 3,658
  • Gender: Male
  • le sigh
    • View Profile
    • rbredlau
Re: MYSQL vs MSSQL
« Reply #2 on: September 30, 2010, 08:00:16 PM »
My coworker uses ODBTP for talking to MS SQL on both Windows and Linux.  I've used ODBTP on Windows and unixODBC with FreeTDS on Linux to talk to MS SQL.
Logged
Pages: [1]
« previous next »