Previous Thread
Next Thread
Print Thread
Hop To
#2300 08/03/2006 1:02 PM
Joined: Jul 2006
Posts: 35
newbie
newbie
Joined: Jul 2006
Posts: 35
Gee, my first post here. laugh

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
guod #2302 08/03/2006 1:12 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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.

Rick #2306 08/03/2006 2:25 PM
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
guod #2307 08/03/2006 2:54 PM
Joined: Jun 2006
Posts: 346
R
enthusiast
enthusiast
R Offline
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.

guod #2308 08/03/2006 2:55 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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.

Rick #2368 08/05/2006 10:29 PM
Joined: Jun 2006
Posts: 46
J
newbie
newbie
J Offline
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."
Jamin #2378 08/06/2006 6:42 PM
Joined: Jun 2006
Posts: 346
R
enthusiast
enthusiast
R Offline
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.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)