Re: Data migration strategy.

L Lusiana wrote:

>Hi All,
>
>I have the following scenario:
>
>Software version 1.0 owns schema A.
>User of the software adds customised data into the schema.
>
>Software version 1.1 owns schema B.
>Schema B is schema A with modifications (eg. tables(s) added/removed,
>columns added/removed, rows added/removed, etc.)
>
>Both software use Oracle version 1.8.6 on SunOS.
>
>What would be a good way to migrate the customised data from schema A
>into schema B? This would need to be done during s/w upgrade from 1.0 to 1.1.
>Can export/import be used? However, I'm not sure how it will handle the
>different table definitions, etc.
>Or, can it be done using sql scripts which finds the customised data
>in schema A and insert it into schema B.
>
>Any ideas and/or references on this areas will be appreciated.
>
>Thank you.
>Lucy
>
>

First thing I would do, assuming your 1.8.6 is just a dyslexic 8.1.6 is upgrade to a version of Oracle
that has been supported in this millenium and has an optimizer that is actually functional. Then I would
use scripts.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)