MS-SQL 2000

If it gets enough votes I'll try to rewrite queries in vBulletin to work with Microsoft SQL 2000. If anyone is interested, feel free to post comments and suggestions.

Oops. Looking at the thread's subject... <ahem> MSSQL 2000 not MySQL 2000. Sorry for that...

I'd write a MS-SQL 2000 database class for it but don't have access to a $20,000 MS-SQL server that I could do it on.

I'm not sure what stands in EULA but if it'd be for testing purposes only... I could send it as an attachment.
Feel free to contact me, we might find a solution.

Thanks for editing thread's subject.

when I get time (*lol*) Im gonna try and port this to PgSQL ( he says )

this is a great idea ok its sound sad if you can't effort a sql server but when you have access to it its cool its a great idea

Originally posted by PeF
I'm not sure what stands in EULA but if it'd be for testing purposes only... I could send it as an attachment.
Feel free to contact me, we might find a solution.

Thanks for editing thread's subject.

For development you have to purchase a "Developer's" License which is about $500 dollars and allows 8 concurrent users, I believe.

I have a copy of SQL Server 6.5 and SQL Server 7.0 so the software isn't really a problem as basic syntax hasn't changed in 2000. However to run it properly it needs to be on a server, preferably Win2k. That I don't have.

I have a site license of Win 2K Server / SQL 2000 Enterprise -- not sure how it would work, perhaps I could set up some DB space or something if you were really interested in doing it.

However the LARGEST strength of Postgres, SQL Server, Sybase, Oracle, etc. is that they support MANY more features than MySQL, namely stored procedures, triggers, etc. -- and to REALLY make a port it's not just swapping out the DB class for a new one (that and INSERTS are different, etc. through vendors) -- it's re-writing the queries to take advantage of subqueries, stored procedures, triggers, etc.

The abstraction class in vB is nice, but there are no easy ways to do a 1-for-1 swap of db.php and expect it to work.

i have read your post on Why you don't like mysql...quite complete.....but now for Vbulletin what could be the better and the fastess db we could use do not look the price....event if its 10 000 $....

If money were no object, SQL Server 2000 and Oracle would be the best bets.

Both can support multiple machines in a server farm, tens of thousands of users and much more.