Yes the proc license is really the only way to go... The difficulty in switching depends greatly on your code. IT could be quite easy - or require rewriting every query.
I recently helped a customer go from MySQL to MSSQL and I wrote a couple of posts on it. It will give you an idea of the type of difficulty you might encounter. http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m ssql Hope this helps (a little) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Billy Cox [mailto:[email protected]] Sent: Friday, September 04, 2009 10:18 AM To: cf-talk Subject: Stung by HostMySite price increase? We recently got a note from HostMySite (now Hosting.com) telling us about a big price increase in SQL Server licensing. We've had a dedicated server with HMS for about a year and the mere thought of shopping for a new hosting provider makes me feel tired. Has anyone else encountered this? We have considered purchasing our own SQL Server licensing and I am wondering (predictably) whether a processor license is the only way to go for a web app database. How hard is it to switch from SQL Server to MySQL? -- *Billy Cox* IT Manager *Old World Spices* [email protected] 816.861.0400 x138 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
