Data migration strategy.

From: L Lusiana <l02_at_uow.edu.au>
Date: 22 Oct 2003 23:13:27 -0700
Message-ID: <2859276f.0310222213.3875a0fb@posting.google.com>

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 Received on Thu Oct 23 2003 - 01:13:27 CDT