Results 1 to 5 of 5
  1. #1
    Amod is offline Member
    Join Date
    Jan 2010
    Posts
    2
    Rep Power
    0

    Question Keeping two schema in sink

    Hi

    My requirement is that I need to create a staging environment whose db should be in sink to prod db.

    Every time an insert or update query fired on prod db should be reflected in staging db.

    Please suggest some approach to achieve this.

    Thanks!

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    The Database should provide a replication software/service.

  3. #3
    Amod is offline Member
    Join Date
    Jan 2010
    Posts
    2
    Rep Power
    0

    Default

    Quote Originally Posted by masijade View Post
    The Database should provide a replication software/service.
    Please give some approach how that service or software can be created.

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    Why? Ask your DB vendor. I can guarantee that one already exists.

  5. #5
    Tolls is online now Moderator
    Join Date
    Apr 2009
    Posts
    11,446
    Rep Power
    18

    Default

    Presumably at some point you turn this synching off so you can actually use the staging environment for, well, staging?

    In which case why the synching, because you'll have to somehow get it back in synch after you've done your staging work?

Similar Threads

  1. Keeping one window above another
    By porchrat in forum AWT / Swing
    Replies: 3
    Last Post: 01-27-2011, 08:11 AM
  2. Serializing BufferedImage with keeping transparency
    By Spitfire777 in forum Java 2D
    Replies: 2
    Last Post: 12-15-2010, 07:49 PM
  3. Keeping data in memory
    By roud9 in forum New To Java
    Replies: 1
    Last Post: 11-02-2010, 12:28 AM
  4. Keeping a graphic central
    By Josisco in forum AWT / Swing
    Replies: 1
    Last Post: 10-24-2010, 06:38 PM
  5. XML Schema
    By Abder-Rahman in forum XML
    Replies: 1
    Last Post: 02-22-2009, 04:33 PM

Posting Permissions

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