Repository migration steps
Posted: Tue Mar 19, 2013 7:10 pm
We are trying to migrate repositories in Oracle 10G from one database to another. This is for 8.0.1 (Windows) and 8.1(Unix) and we have both parallel and server jobs. I came up with the following steps:
1) Back up the current XMETA schema to another schema.
2) Back up all Datastage objects.
3) Create a DBLink to DBTgt from DBSrc.
4) Create the XMETA schema and the tables in the DBTgt.
5) Insert the source records into the target database.
This is very high level and I know I missed tons of steps. Can anyone add any additional steps?
Appreciate your help.
1) Back up the current XMETA schema to another schema.
2) Back up all Datastage objects.
3) Create a DBLink to DBTgt from DBSrc.
4) Create the XMETA schema and the tables in the DBTgt.
5) Insert the source records into the target database.
This is very high level and I know I missed tons of steps. Can anyone add any additional steps?
Appreciate your help.