It is mostly inserts and updates we are doing. I don;t think there are any deletes. I'll try and explain the situation in a little more detail to give you a better idea of the situation.
We have people in several countries gathering data which is then synced back to a central server. A table on the server would have a definition similar to this.
CREATE TABLE [table_name](
[ID] [int] IDENTITY(0,1) NOT NULL,
[CountryName] [nvarchar](50) NOT NULL,
[date] [datetime2](7) NOT NULL,
[data1] [smallint] NULL,
[data2] [smallint] NULL,
)
This holds data for all the countries we gather data from. Using a filtered scope I create a database for each country which only hold data applicable to that country. This is then given to the data gatherers in each country and used with our application
to storing data on there local machine and for syncing back to the central server. I should also point out that there is a client database which contains data for all countries. When I create the client database I tell it to GetDescriptionForScope
for all scopes rather than just those relating to a 1 country.
Because of this "allcountries" database there would be overlap in data between scopes, however I found in my tests that this worked fine. Entering data on a single country db syncing to the server and then doing a sync between an "allcountries"
DB and the server brought all the data down to the all countries DB. The problem seems to be where I have 2 of the same single country DB. Change data in 1, sync to the server and the sync to the second and none of the data comes down to the 2nd client.
