Reputation: 311
Is it possible to use one table in different scopes with different number of columns? Means that, in scope1, [table A] contains all the columns and in scope2 ,some columns are removed from [table A]. Also need to mention that scope1 and scope2 are in 2 seperate applications.
Upvotes: 0
Views: 378
Reputation: 7860
that should be possible. easiest will be to provision your scopes on different schemas so you have completely different Sync Fx objects for each scope.
you will have to take into consideration if columns does not allow nulls (i.e., a column does not allow nulls and is omitted from a scope, the insert or update will fail for that row)
Upvotes: 1