Yes @BabyAqua,
It can handle schema sync as well if required
I am very interested in learning your setup, Srikanth. How difficult would it be to setup?
I saw your prereq. What does this mean?
"Source database tables should have enabled with Change tracking."
Would you be able to share the walkthrough from a hardware requirement to the setup? Do I need two servers?
"synchronizes reporting server with transaction server"
I have intermediate knowledge of SQL Server.
Please go through SQL server's change tracking feature,
The synchronization solution that I am talking can't be explanatory in the chat.
It can't be set up with the fewest settings as like availability groups. As it is a database solution, we should have fewer control tables and procedures to make tables data and schema in sync.
Thanks,
Srikanth chindam