SyncFx 2.1，即使在过滤时也会下载太多记录（具有多个Compact数据库的客户端） [英] SyncFx 2.1, Downloading too many records even when filtering (Client with multiple Compact databases)

问题描述

我有一个SQL Server主数据库，有几台客户端PC连接到它。每台客户端PC都有许多SQL Server Compact数据库。每个SQL Server Compact数据库都包含允许可移植性的单个客户的信息。此信息
与主数据库同步，主数据库包含所有客户的信息。

I have a SQL Server master database with several client PCs connecting to it. Each client PC has many SQL Server Compact databases. Each SQL Server Compact database contains the information for an individual customer to allow portability. This information is synchronised with the master database which contains information for all customers.

我有一个过滤器，因此Compact数据库只能同步1个客户的信息。

I have a filter in place so that a Compact database can only synchronise the information for 1 customer.

我遇到的问题是，当我在客户端PC上的Compact数据库之间切换并同步数据时，我获得了下载到Compact Database的另一个客户的信息。更奇怪的是，只下载来自
的信息，这是先前配置的Compact数据库。

The problem I’m having is that when I switch between Compact databases on the client PC and synchronise the data I get the information for another customer downloaded to the Compact Database. What’s more strange is that only information from a previously provisioned Compact database is downloaded.

例如，我有客户A，B和B的主数据库。 C和一个拥有3个客户紧凑型数据库A，B和B的客户端。 C.最初，紧凑型数据库或主数据库都没有任何配置。如果我然后为
客户A同步Compact数据库，则同步工作完美。我甚至可以将这个Compact数据库从PC 1复制到PC 2，在PC 2上对其进行更改，将其同步到主设备，然后将其正确地同步回PC 1。但是，当我为客户B同步客户端Compact数据库时，我也得到了客户A的
记录。我认为这可能是我的过滤问题，但奇怪的是，客户C的记录未与B同步。

For example, I have master database with customers A, B & C and a client with 3 x customer compact databases A, B & C. Initially, none of the compact databases or master database have any provisioning. If I then synchronise the Compact database for customer A the sync works perfectly. I can even copy this Compact database from PC 1 to PC 2, make changes to it on PC 2, sync it to the master and then sync it back to PC 1 correctly. However, when I sync the client Compact database for customer B, I get records for customer A too. I thought this might be a problem with my filtering but it’s strange that the records for customer C are not synchronised to B.

此外，当我查看master数据库时，记录对于每个数据库，我在过滤的列中都有正确的值。

Also, when I look at the master database, the records for each database have the correct values in the columns I am filtering by.

我尝试为每台PC和每个客户使用不同的同步范围，但我仍然遇到这个问题。

I have tried using different synchronisation scopes for each PC and each customer but I still get this problem.

任何可能出错的想法？​​

Any ideas what could be going wrong?

推荐答案

我注意到如果我从中删除配置在我同步第二个客户数据库之前的主数据库（上例中的B），同步工作。不幸的是，这不是一个修复，因为我需要为每个
Compact数据库重新配置master数据库并丢失跟踪信息。

I've noticed that if I remove the provisioning from the master database before I synchronise the second customer database (B from the above example), the sync works. Unfortunately, this isn't a fix as I will need to reprovision the master database for every Compact database and lose the tracking information.

这篇关于SyncFx 2.1，即使在过滤时也会下载太多记录（具有多个Compact数据库的客户端）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！