Bryan Stevenson wrote: >> >> What sort of support do you mean? Are you afraid it will suddenly >> stop working? > > As has been said lately on list....you get what you pay for... Crap I said > I wouldn't get into this...just wanted a little help and I get jumped o by > the open source police ;-) > > Listen...free stuff is free until you run into it's limitations
Expensive stuff is expensive until you run into its limitations. Then it becomes very expensive. The point I am trying to make is that you know the requirements of your application and the limitations of a database when you develop your product. At that point you have a list of requirements and a database either meets them or doesn't. If it doesn't, you remove it from your list of options. In your case, if better referential integrity then MySQL currently offers is in the list of requirements, you should remove MySQL. If you have 'vendor must have 24/7 support in 12 countries/4 languages' in your list you can pretty much scrape everything but DB2, Oracle and MS SQL Server. But when it turns out that PostgreSQL, Firebird and Ingress meet the criteria, don't remove them just because they are free. > nuff said...I got my help...21 of the 50 odd tables will NOT import into MS > SQL via the MySQLODBC 3.51 driver so now I have to find out what kind of > crap in MySQL is causing the create table scripts to fail. ENUM datatype and MS SQL Server keywords. And when you get to importing your data you get the added pleasure of 0000-00-00 00:00:00 dates, overflowing decimals and fake NOT NULL constraints. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

