There's a thing called the oracle migration workbench that could be of some help. I've never actually used it because the DBA's restrict our use of it here. But, it might help.
There's always just creating an access datasource in CF and running queries to enter it into Oracle. I do that when I don't want to fiddle with asking for DBA permission. On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > Hey All, > > I have an Access DB that needs to move to Oracle 9i. The Oracle DB has > been created and then generated via Oracle Designer and does contain > different table names than the Access DB, and some tables will have > less/more columns than their Access counterparts. In some cases their will > be additional columns on the Oracle side that I will need to add a default > value to (so not data that comes from the Access DB). > > So does anyone have advice to transform this data from Access to Oracle > given the above issues? ....and before you say flat file....re-read the > above ;-) > > TIA > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
