Actually, I like Oracle. I have a lot of fun with it. I'm sick. I know. -d
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 11:16 AM Subject: RE: Access to Oracle > Hey thanks for that BTW just what I needed :) > > Tim > > Oh and I hate oracle more than..... hmmmm well a lot of stuff. It sucks. > Bad, Bad oracle. > > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 12:03 PM > To: CF-Community > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
