The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 03-20-2001

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.

#2 03-20-2001, 11:29 AM

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

#3 03-20-2001, 11:59 AM

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.

#4 03-20-2001, 12:34 PM

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.

#5 03-20-2001, 09:09 PM

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

)

#6 03-21-2001, 10:19 AM

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

#7 03-21-2001, 11:20 AM

Quote:

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.

#8 03-21-2001, 01:58 PM

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.

#9 03-21-2001, 04:21 PM

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 $....

#10 03-21-2001, 04:24 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04467 seconds Memory Usage 2,262KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!