How often have you seen a company switch database vendors?
We've switched stuff between SQL Server and Oracle (and between Access and SQL Server / Oracle).
The DB is really good at handling constraints and complex queries / updates so we use SP / triggers where it makes sense but we keep the vast majority of our logic in CF. We have a small, dedicated team of DBAs but a much bigger pool of CFers so from a resource point of view, doing everything in the database wouldn't make sense for us for web apps. For other enterprise apps - ERP, CRM - the story is somewhat different because those aren't 'programmed' systems - they're packaged systems so the easier avenue for customization / integration is through the database.
At the end of the day, use what you feel most comfortable with...
Regards, Sean
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
