Actually, if you've outgrown Access and can't afford MS-SQL, MSDE is probably a better answer since it saves you converting SQL twice -- once to MySQL and once to MS-SQL down the road.
Better plan is to code for the db you plan to use -- MSDE from the beginning if you're heading for MS-SQL, MySQL if you want MySQL, etc. Database conversion is a pain. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Massimo Foti" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 5:51 PM Subject: Re: MS SQL Server vs. MySQL > "Matt Robertson" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > Now if it's missing all that then what is it....Access on > > > steroids?? ;-) > > > > Yes, precisely. All the basics and none of the fancy stuff, plus speed. > > Speed when you read data, on insert it can slow down quite a lot. I don't > know about version 4.x, but older versions used to lock on write at the > table level; totally insane in my opinion. > > It can also slow down developing since it doesn't enforce referential > integrity and you have to do it on the application (same for cascading > delete) > > > > If you've outgrown Access and your budget is not ready for the MSSQL hit > > then mySQL is a viable alternative. > > I really think that in this scenario Postgres is a much better alternative, > but maybe it's just me... > > ---------------------------- > Massimo Foti > Certified Dreamweaver MX Developer > Certified Advanced ColdFusion MX Developer > http://www.massimocorner.com/ > ---------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
