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.
Repository migration steps
Moderators: chulett, rschirm, roy
Review the following presentation regarding how to perform that migration. It details the steps you need to take.
Relocating the XMETA repository for Information Server 8.0.1 and 8.1
Regards,
Relocating the XMETA repository for Information Server 8.0.1 and 8.1
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.