MS SQL 2005 has been out for awhile now, is a solid platform, has some very nice advanced features at the data management level, improved support for xml, and better support for today's larger, beefier machines.
MySQL 5 is really nice, finally bringing some nice enterprise SQL functionality (like stored procs, triggers, views, cursors, clustering). The syntax is very similar, with some nice additions (like LIMIT). It's been out for awhile now, and is definitely showing to be an enterprise class db platform. Toolsets for working with it have improved significantly, licensing is much kinder on the wallet, and it can run on more than one OS platform, opening less expensive hardware/OS options. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com Andy Chen wrote: > My vote is SQL Server 2000 since it is very mature and that is the one I have > been using. I haven't tried MS SQL 2005, but I would let the beta testers.. > umm... users work out the bugs first and then migrate SQL 2000 - SQL 2005 > sometime in the future. > > In my opinion, don't go for mySQL if you are building something for an > enterprise. >> Hi to all, >> i have to create a Database Server to work with ColdFusion. I'd like >> to know what is (obvious by your personal opinion) the best Database >> Engine to use (performance level, easiest sql language,compatibility, >> etc...). >> That are my requirements: >> - Op.System: Windows 2003 r2 Standard Edition >> >> - My possible DB Engines: > >> 1- SQL Server 2000 > >> 2- SQL Server 2005 > >> 3- My SQL > >> N- etc...(suggestions accepted, not oracle) >> >> >> Tank you all > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
