|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 23rd, 2004, 09:11 AM
|
|||
|
|||
|
MySQL to MS SQL
I have a discussion forum which was developed in PHP using MySQL as the database however, dispite constantly reminding the client that their host needed to support MySQL, they have chosen a host that only supports MS SQL.
I'm afraid I know very little about MS SQL but wondered if anyone here can suggest the best solution e.g. convert the PHP queries etc to suit MS SQL (if so where can I find out which ones?), look for another forum which uses SQL or would all this be more trouble than its worth and I should tell them to forget it??? Many thanks in advance for you help
|
|
#2
July 23rd, 2004, 10:04 AM
|
||||
|
||||
|
You could convert your forum to Php ADODB thus achieving database independence.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > MySQL to MS SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
