> I am curious as to which 'good reasons' result in database > requirements that open source databases can't meet. I can think > of a few (synchronous multimaster WAN replication, extreme OLTP > throughput etc.), but none that I would see in 'most systems'. > > Jochem
As I've said before....I...that's me...myself and I (and all of our opinions) that MySQL straight out of the box is missing key features (like ref integrity) that should exist in ALL databases....I just can't see why it wouldn't. Then you'd have to add on other MySQL packages to make it into a "real" database. Each of these comes with it's own set of unique *ahem* features...just like MySQL is not ANSI standard (governments like standards Jochem).....doesn't support transactions (without an add-on). I also mentioned political reasons.....the CEO like Oracle....the government is standardized on Oracle....and so on... My own experiences yesterday (NULLs in NOT NULL columns) have once again proven to me that MySQL has issues (and oh my....that MySQL "gothca" page scares me). Of course the biggest factor in the selection of moving to MS SQL and then to Oracle WAS NOT MY CALL....I'm not the decision maker here...I originally just asked for help importing MySQL data into MS SQL. BTW...what ultimately worked was sucking the tables into Access and then into MS SQL...now I have to setup my PK/FK and fix up the data types Just remember....good reasons are not always technical ones (like perhaps a system has to be built extremely fast and picking a DB that the team doesn't use daily will only introduce unwanted unkown issues along the way that there is no time for) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205855 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
