Dave Watts wrote: >>What about if you're using an outdated version of MSSQL, and >>you'd have to pay $20,000 to upgrade to 2005? I'd be >>inclined to look around for cheaper DBs. > > > If you don't need SQL Server Enterprise or Standard functionality, SQL > Server 2005 Express is free. If you do need the sort of functionality found > in Enterprise (as opposed to Standard), a lot of it doesn't exist in MySQL > to the best of my knowledge. > > For the record, I'm not saying there aren't any good reasons to migrate from > MS SQL Server to MySQL, just that price isn't necessarily one of them. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/
I've always found it easier to migrate from MS SQL to PostgreSQL personally. As long as your SQL queries are SQL standard compliant, it should be cake. I've done this with *many* sites. PostgreSQL is wonderful - and more liberally licensed then even MySQL. Dave, I can think of plenty of reasons to migrate away from MS SQL. How about platform independence? How about affordable clustering? How about unlimited user connections? How about redistribution rights? Rebranding? No-cost upgrading? Oh yeah, and on the costs issue, don't forget that in addition to the staggering cost of MS SQL Server itself, you are also forced to run it on a MS OS - which costs another very shiny penny. Cost is certainly a factor - and usually the one board members care about the most. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
