On Thu, 24 Feb 2005 08:33:40 -0800, Spike <[EMAIL PROTECTED]> wrote: > That's a ridiculous thing to say without at least qualifying it.
Agreed. No better than blithely saying MySQL rules because it's open source :) > MySQL is a far better tool for me than MSSQL because as a developer I > often need to be able to destroy an existing database and replace it > with a backed up version. > > With MySQL I can do that in a matter of a couple of seconds from the > command line, or from a batch file. With MSSQL I need to open up > Enterprise manager and run the restore database backup function praying > that CFMX has dropped any existing connections because if it hasn't I'll > have to go stop that before doing the restore. Actually, that's not fair at all. You can use T-SQL and the osql command line just as effectively, though it takes more steps and isn't as intuitive since MS has forced you to think "GUI". It takes a similar amount of steps to restore a database through the MySQL Administrator GUI too.... if you can at all (so used to command line I haven't checked...) > There's no doubt that there are times where MSSQL is a better fit, but > blythely assuming that it's always the case is naive at best. Agreed. I mean there's PostgreSQL, Firebird, and Derby in the open source arena alone. And in the commercial world there's also Oracle and DB2, which now are pretty price-competative with MS-SQL. Oh, and things like Cache. And Sybase is still around. It's not always a MS-SQL vs MySQL decision and like Spike implies, knowing the problem you're trying to solve is the important part of the process -- not blithely assuming paying for something (or getting it free) makes it better. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
