not so easy , need triggers to be implemented for all the tables in onprem env.. any schema changes occurs a changetracker table should have all the history regarding schema changes . further create ddltrigger to read all the changes in changetracker table and act to sync..

Hi Zahid, How can cross-database queries will help here?

Hi you can Cross database Queries.

Please suggest.