It's pretty typical that multiple models shares conformed entities. You may have client specific services, fiscal calendars, work order types, etc. and created different models based on concept. Client entity shows up in some of models.
But you want the client entity to be synced among these models. One model containing the entity works as master and other models as slave.
In SQL Server 2016, it provides the "Entity Sync" function that meets this request. To create the entity sync steps:
1: Go into "System administration"
2: Select "Manage-->Entity Sync"
3:Click "Add" and then follow the instructions:
4: After click "Save", it executes immediately if "Sync on Demand" is selected. The entity is copied to the target model with data. If you just need copying the entity, you could delete the sync task. If you want the master-slave mode, then "Auto Sync" should be selected.
Reference:
Create and Execute an Entity Sync Relationship (Master Data Services)
Comments
Post a Comment