> Microsoft SQL Server tends to be the most used by CFers simply because > most use Windows, and the admin UI is great, most of your SQL will work > as is (and Access to SQL Server migration is good), but SQL Server is > not cheap.
But MSDE *is* cheap -- it's probably on your MS Access CD and is also bundled on just about any other MS development tool CD (eg VB, Visual Studio, etc). MSDE is the sql-server engine without the high-end features. It's often used as an embedded database in applications that don't even advertise they have a db backend (eg HP OpenView for one). Plus there have been some great articles in CFDJ on using MSDE for CF development to help you along. If you're planning on SQL-Server down the road, using MSDE now saves the whole MS Access-MS SQL conversion. > Oracle is popular in higher-end installations, very good database, UI > tools leave much to be desired, the SQL tends to be less compatible with > most everything else, and it is pricey too. nuff said > MySQL is the least expensive (can't get much cheaper), works well, > missing some important functionality, admin tools by default are all > command line but they are third party admins (some that are starting to > look a lot like SQL Server Enterprise Manager). Just a quick note, the MySQL Control Center (mysqlcc) is available from MySQL AB directly, is free, and looks a lot like Enterprise Manager. The other common choice is SQLyog, which is pretty cheap. If you can live without storedprocs (til version 5.0), without subselects (though the current 4.1 alpha has already implemented them), and don't need triggers (v 5.0 again) you've got a winner. Plus the 4.0 memory cache is pretty amazing in production (grab a 64-bit opteron box, put in 8 GB of RAM, and set the memory cache to the size of your database. Whoosh! Access times in nanoseconds instead of milliseconds. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4