How to sync clone DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to sync clone DB

  1. #1
    Join Date
    Jan 2002
    Posts
    148

    How to sync clone DB

    Hello,

    Please suggest what should i use to sync the newly Cloned DB.

    What would be Possible solutions to use, so as to propagate the DMLs from Dev1 to Prod1 ?

    DataProcessing on Dev1 ---> Production running on Prod1

    Only 2 table needs to be propogated.

    The tables are over 800Million Recs/200GB each.

    1) Standby - mostly not, cause, the Prod server needs changes to other objects which might not be available with Dev server in future.
    2) Replication/ Materialized View - is it possible ?
    3) Simple trigger machanizm can be given the least priority.


    Please suggest !!!
    Thanks
    Jr.

  2. #2
    Join Date
    Oct 2002
    Posts
    807

    Re: How to sync clone DB

    Originally posted by Jr

    1) Standby - mostly not, cause, the Prod server needs changes to other objects which might not be available with Dev server in future.
    2) Replication/ Materialized View - is it possible ?
    1. What do mean? I don't understand. Heard of logical standby? You can replicate specify tables.
    2. Yes. Streams would be another possibility.

  3. #3
    Join Date
    Oct 2002
    Posts
    807
    Several 3rd party tools will do the job as well - shareplex is a popular one.

  4. #4
    Join Date
    Jan 2002
    Posts
    148

    Wink

    Thanks for the reply Axr !!!
    I will start working on Logical Standby and Shareplex.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width