Great article

TOAD from www.quest.com will assist you to do lot of your steps
If you want use WEB Base Oracle query interface, I wrote one with ASP
for copy please e-mail to me, It will transform Oracle table/view data
into your browser table view or EXCEL, base on your query (pont and click)
[log in to unmask]

www.exmlsoft.com

Dennis Hassell <[log in to unmask]> wrote in message news:<[log in to unmask]>...
> I have not gone to Oracle Apps, but I have some Image to Allbase/SQL
> experience which, theoretically, would be the same basic method.
>
> Steps 2 and 3 are very related and are the essence of the new DB. In
> this case, you are NOT doing a full review and redesign, but rather an
> injection of data into an existing design, so the guidelines are:
> - Each Detail Dataset will convert to (an) Oracle table(s). It will
> depend on how close to Third Order Normalization the Image database
> design was. Map from Image dataset(s) to flat files, where each flat
> file is the data for ONE Oracle table. Format the flat file to ease the
> loading process as needed.
> - Each Automatic Master may translate to an index in the target DB. In
> Oracle Apps, the indexes are probably predefined, so the Image
> Automatics probably can be ignored.
> - Each Manual Master may translate either to a constraint between two
> tables (with no additional table added), or it will be an additional
> table with constraint(s) to (each of) the tables which were the Image
> Detail tables connected to the Manual Master. In Oracle Apps, the
> constraints and indexes might be predefined, so this just becomes a data
> mapping chore to the flat files.
>
> Do one complete load of the data from the flat files with all
> constraints defined, but NO indexes. This will validate the data
> relationships and use the fewest machine cycles. Remember to load the
> constraining (i.e. master) tables first as they will be needed to
> validate the rest of the data.
>
> Then apply the indexes and test the result.
>
> Correct the data in the Image DB or the flat files, whichever is easier,
> and repeat the load. In future loads, you can load all tables with no
> constraints and no indexes - even faster - then apply them after the
> loading. The few errors you might run into will not take as much time to
> deal with. If needed, apply only certain constraints if you are
> concerned about a certain portion of the data.
>
> Hope that helps.
>
> Dennis Hassell
> Dennis Hassell and Associates
> (941) 746-4919
> (941) 224-3981 - cell
>
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of Jay Chandru
> Sent: Thursday, July 24, 2003 9:33 PM
> To: [log in to unmask]
> Subject: [HP3000-L] Data migration from Turbo Image to Oracle Apps (11i)
>
> Data migration from Turbo Image to Oracle Apps (11i)
>
> 1. Identify the databases and datasets that are to be migrated
> 2. Map fields of each dataset to fields in a relational database
> 3. Establish the relation ships in the relational database
> 4. Apply validations and correction routines to the data in relational
> database
> 5. populate oracle internal tables from the relational database
> 6. run oracle interface to populate the oracle apps tables
> 7. Repeat this process until the data migrated is clean
>
> If anybody has worked on a similar assignment or anybody who has an idea
> about the possible holes in such a migration or any damn knowledge of
> the
> same, pls. share
>
> Thank you,
> Jay
>
> _________________________________________________________________
> They are beautiful. They are in danger.
> http://server1.msn.co.in/Slideshow/BeautyoftheBeast/index.asp Our
> four-legged friends.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *