Post
Ask Question

Abhijit Kakade
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 ?
By Abhijit Kakade in Azure on Apr 02 2017
  • Vijay Saxena
    Jan, 2020 10

    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..

    • 0
  • Abhijit Kakade
    Mar, 2018 28

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

    • 0
  • zahid neaka
    Mar, 2018 27

    Hi you can Cross database Queries.

    • 0
  • Abhijit Kakade
    Apr, 2017 2

    Please suggest.

    • 0


Most Popular Job Functions

View All

MOST LIKED QUESTIONS