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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
