Using XML to migrate data from one DB to another.

Hello!
I'm guessing someone else has come across this problem:

We have an oracle database-driven reporting application. For simplicity's sake, let's say there are four instances of this application: Development (DEV), Integration (INT), Staging (STG), and Production (PRD). These are used to migrate application code (DDL changes, etc) from DEV->...->PRD using a SQL*Plus-based migration tool.

The main product of this database is a report definition. A report definition is made up of various tables linked by numerous foreign keys.

Our problem is this: users want to use the STG instance to preview new reports that are to be created in PRD. Because I can't guarantee the primary key/foreign key values in one DB instance will be the same as the next (we're using sequences), I can't simply export the DML for a given report definition entity (including all of it's foreign key relationships) and run it in PRD because I can't be sure that all of the entities being referred to exist/don't exist.

I'm guessing someone has come up with a solution using Oracle XML DB (an API with which I am familiar).

Any suggestions?

Thanks,
Leo Received on Mon Jun 09 2003 - 13:31:39 CDT