SQL Server Express isn't an option due to size limitations, although we may scale back from Standard edition to Workgroup. We chose Standard initially in order to take advantage of SSIS, but we haven't had the time to become proficient with SSIS and have moved our old DTS scheduled jobs to CF scheduled tasks.
Judah McAuley wrote: > 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:326003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
