Oh, delicious sequences. They make handling surrogate key so much easier....
----- Original Message ----- From: Deanna Schneider <[EMAIL PROTECTED]> Date: Friday, February 14, 2003 10:02 am Subject: Re: Access to Oracle > Hey Timothy, > There's an "Oracle Migration Workbench" that can be used to import > Access to > Oracle. I don't know if it handles writing the triggers for you, > but it's > pretty simple. > > Actually, I don't use triggers much anymore for auto-incrementing > ids. The > reason is that it's not reliable to do the old "wrap 2 queries in a > cftransaction, insert your data, and pull the maxid" trick with > oracle.(There's an implicit commit between the 2 queries, even > with the > cftransaction.) Instead, I do a cfquery where I pull the next > value from a > sequence, then insert it as the new id with my other data. > > If I don't need the new id somewhere else on the page, you can > just insert > the next value from a sequence (mysequence.nextval), which is even > easier.And, it means there aren't any triggers to maintain. > > -d > > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Community" <[EMAIL PROTECTED]> > Sent: Friday, February 14, 2003 10:28 AM > Subject: Access to Oracle > > > > Hi, > > Wondering if anyone knows an easy way to upsize an Access db to > Oracle? > > I mean, man is this looking like it's going to be a pain, > triggers, and > > constraints and all will have to be totally written from > scratch. What > kind > > of db doesn't have a field that doesn't auto-increment damnit. :) > > > > Timothy Heald > > Overseas Security Advisory Council > > U.S. Department of State > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
