Automate delta changes, IUD, between 2 database and push the changes to a 3rd database

Philips, Garry, PED 0 Reputation points
2024-03-19T16:20:09.08+00:00

We currently are using a manual, GUI, process with Redgate to generate the insert, update, and deletes statements that occurred between two databases, the same full database backup at midnight, day to day. These changes are pushed to a 3rd database used by a web app so users and selectively push transactions to a 4th database. We need to automate the delta between 2 databases and push these flagged rows as inserts, deletes, and update into the 3rd database.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,211 Reputation points
    2024-03-21T02:04:29.97+00:00

    Hi @Philips, Garry, PED,

    You may try to create an audit trail in the changed database and then use SSIS to load the table to 3rd database.

    Check Create a Simple SQL Server Trigger to Build an Audit Trail

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments