Failed to create new database

[NorbertKrupa]

When you load data, you load it into your primary cluster and secondary/DR.

[chenshaulian]

Now, after the the DR environment aligned with the primary environment, we have jobs that load data into booth environment.

Does anyone know if there is a way to implement service/ agent/ anything that will update the DR site automatic at any change that we do in the primary site (like replication on SQL server) ... I need to keep the DR site aligned all the time as much as I can ...

Thanks

[NorbertKrupa]

Non-third party solutions are typically hand-built processes that replicate users, DDL, etc. (sometimes done from a repo).

There are other options like Tervela or DBMoto for replication, but storage replication has it's own disadvantages. It's important to do a RPO/RTO analysis to determine the best strategy.

[chenshaulian]

OK, thanks