Morning Sean.. > We've switched stuff between SQL Server and Oracle (and > between Access > and SQL Server / Oracle).
OK that's one ;-) Just wondering, were you able to pick up the SQL and move it to the new RDBMS without a problem, because all the logic was handled at the CF end? > 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. I guess when you read my comments you'll need to keep in mind that I am just as comfortable with MS SQL as I am with CF, most of the apps I rollout are enterprise. > 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 --- 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
