Version 2023.2.1

You can now view the additional column hvr_change_seq introduced in the replica tables. This column contains information captured from SQL Server databases, which is then replicated to MDC's data storage using High Volume Replication (HVR) for further analysis and reporting. The new hvr_change_seq column in the replica table will contain a sequence of unique values (unique identifiers) corresponding to the changes or transactions made in the source database (SQL Server) during the replication process. These values will be assigned in incremental order, ensuring each new transaction will receive a value higher than the previous one. This arrangement ensures the preservation of the values in sequential order and integrity of replicated data in the MDC's data storage.

The MDC load stored procedure in the MDC system will first process and load the most recent or latest updated record into the MDC environment by sorting the transactions from the replica tables based on both hvr_cap_timestamp (time of change) and hvr_change_seq (sequence of change). This ensures that the replica tables in MDC's data storage are populated with the most current data.