CREATING CONSISTENT COPIES OF A DATABASE

A system generates consistent copies of data stored in a source database in a plurality of target database systems. The system sends a change data stream from the source database system to the target database systems for performing data updates. The system receives timestamps of a latest transactions processed by consumer processes updating the target database system. The system determines a pause timestamp that occurs after the received transactions. The updates to the target database systems are paused once a transaction corresponding to the pause timestamp is processed. The pause timestamp is used to generate a consistent copy of a source database system in a target database system using multiple partitioned change data streams, each partitioned change data stream processing transactions associated with a partition of the source database system.