Jump to content


Photo

MySQL to MSSQL?


  • Please log in to reply
2 replies to this topic

#1 croakingtoad

croakingtoad
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts
  • LocationUSA

Posted 19 April 2006 - 07:28 PM

I am working for a company who uses MSSQL but I would like to run an open source PHP app that uses MySQL. Forgive my DB ignorance, but is there a wrapper class or anything I could (easily) use without having to rewrite the entire open source apps DB code for MSSQL?

Thanks!

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 19 April 2006 - 07:42 PM

The difference is almost negligable.

mysql_functionname go to mssql_functionname
You can't use some of the specific MySQL options (LIMIT being the big one)

I use both and it's never really a problem for me. If you run into any problems or have a question about something specific, post it here or PM me.

Info: PHP Manual


#3 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 19 April 2006 - 07:55 PM

A big difference will be found if make use of MySql functions, especially date functions, in your queries.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users