I am performing parallel testing. We have upgraded the legacy batch jobs to a new framework which we need to test against the existing batch jobs.
In the existing setup, I have web application which creates or updates records based on user input and these batch jobs will process the records.
The plan is to have 2 databases, primary and secondary, with the existing batch job connected to the primary database server and the new batch job connected to the secondary database server.
The web application will populate data to both primary and secondary databases.
I would like to perform replication for all the tables in the database. However, I would only like to replicate any DML changes done by the specific database account used by the web application.
Is that possible?