Like most things, the answer to all your questions is "it depends".
If you have an app that doesn't have a big load, SQL Server Express might do fine for you. It is free but will only use 1 processor core, 1 GB of RAM and has a 4 GB database size limitation. Porting over to MySql can be very easy or pretty difficult. A lot depends on how you write your code. Do you use an ORM like Transfer or Reactor? If so, then you don't have to worry about the back end db as it is abstracted and the ORM will take care of the db-specific details for you. Do you use a lot of TSQL in your queries? If you have MSSQL-specific code strewn all over, like using SCOPE_IDENTITY() to get back a newly inserted autoincrement id, then you'll have more work to do to translate that over to MySQL-specific equivalents. I'd try setting your app up with MySql. See what breaks. Then try it with SQL Server Express and do some load testing. See what happens. That should give you some guidance. Cheers, Judah On Fri, Sep 4, 2009 at 8:18 AM, Billy Cox<[email protected]> wrote: > > 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:325997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
