Reviewal / Approval logic can easily be added to a streams configuration. Streams consist of a capture, propagation and apply process, each of which can be activated and controlled the way you need it. I.e. you could capture and propagate constantly to an intermediate site, and have the apply process stopped until you're done reviewing your data, and fire it off manually to apply the changes.
Stefan
On 5/25/06, Balakrishnan, Muru <Muru.Balakrishnan@echostar.com> wrote:
Hi,
We are looking for a
tool to migrate delta changes in table rows in a controlled way. Meaning we
should be able to review and approve row changes and migrate to test and
production. I know there are data replication tools such as Streams, Data
Guard, SharePlex etc. but those tools replicate at redo log level or do not
have review/approval logic. Any input in this regard is highly appreciated.
Thanks,
Muru