Keeping two schema in sink

[Amod]

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!

[masijade]

The Database should provide a replication software/service.

[Amod]

The Database should provide a replication software/service.

Please give some approach how that service or software can be created.

[masijade]

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

[Tolls]

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?