There is no right or wrong answer, going to a client-server database is a good thing whichever option you go with. But ...
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. 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. 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). There are other options too, but these 3 prob account for almost all CF installations. --- Ben -----Original Message----- From: Jeff - Development [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 11:26 AM To: CF-Talk Subject: When to switch databases?? At what point would I consider migrating my Access databases to SQL? ... and is there a certain flavor of SQL that I should aim for? Is there specific things to look for? Is there an FAQ on this or some good resources to research.Right now, one database is at around 8 megs and chock full of stuff, lots of tables and data, the other is kinda like a contacts database name address phone etc.... and its at about 3 megs mostly data, few tables... Any help would be apreciated! Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
