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

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.

Thanks for the reply Rick.

A follow-up question. Is there any reason why version 7 wouldn't run on MS SQL?

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.

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.

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

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.