Suppose you are using Azure Data sync service which doing database sync of 2 different SQL azure database. Both databases has few constraints on tables. How you will make sure this tables are getting sync properly ?
Abhijit Kakade
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.