|
|
Joined: Jul 2006
Posts: 35
newbie
|
newbie
Joined: Jul 2006
Posts: 35 |
Gee, my first post here. I know MySQL is the intended database product for version 7, but is there a risk running MySQL and MS SQL on the same server? Have some other apps that require the MS flavor and really don't want to build another box to carry our forums. TIA
Last edited by guod; 08/03/2006 1:03 PM.
guod@simhq [dot] com
twitter.com/SimHQ youtube.com/SimHQcom livestream.com/SimHQ
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Nope, shouldn't be any issues at all. I've had a box with a few different database servers running. The only problem would be if any of them were using the same port, but I think MSSQL is port 1433 while MySQL is port 3306.
|
|
|
|
Joined: Jul 2006
Posts: 35
newbie
|
newbie
Joined: Jul 2006
Posts: 35 |
Thanks for the reply Rick.
A follow-up question. Is there any reason why version 7 wouldn't run on MS SQL?
guod@simhq [dot] com
twitter.com/SimHQ youtube.com/SimHQcom livestream.com/SimHQ
|
|
|
|
Joined: Jun 2006
Posts: 346
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 346 |
You would need to do a major refactoring of /libs/mysql.inc.php for starters. PHP has different commands it uses for MySQL vs MSSQL. I believe that is the only changes necessary.
I think the big chore would be going through all of the /admin scripts.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
All of the queries are MySQL specific which is the only supported database. To run under MS SQL just about all of the queries would need to be alterted in some form.
|
|
|
|
Joined: Jun 2006
Posts: 46
newbie
|
newbie
Joined: Jun 2006
Posts: 46 |
See, this is what I don't get. I thought almost all the different servers (MySQL, MSSQL, Oracle, ad nauseum) were based on some "standard" called SQL 92 or 94 or something. Granted, I've only had any experience with MySQL, so obviously I'm a little biased. But I would think that if all the different flavors are based on the same general specs, a simple query like "SELECT X FROM Y WHERE Z" would translate pretty similarly across all the platforms.
I guess I'm just misunderstanding exactly what the "SQL 92" specification entails.
---Jamin
"Those who would give up essential liberty to purchase a little temporary safety, deserve neither liberty nor safety."
|
|
|
|
Joined: Jun 2006
Posts: 346
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 346 |
Maybe if I'm extremely bored, I'll see if I can't play with DB2 and Threads 7. From what I'm seeing so far, it looks like you would have to touch almost all of the admin scripts in addition to the mysql.inc.php library.
|
|
|
1 members (Ruben),
360
guests, and
168
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|