如何更改范围 - 同步V2 [英] How to change a scope - sync V2

问题描述

我想知道如何处理范围更改，例如在第一次同步后添加/删除范围内的表格？ 

例如，我有一个范围有两个表：A和B.我在此范围内的CE数据库（本地）和SQL Server数据库（中央）之间进行同步。
之后，我们在中央数据库上添加一个新表C并修改表A（添加新列）。我们希望再次将中央数据库与本地数据库同步。
执行此操作的最佳做​​法是什么？创建一个新范围？修改旧范围？我们不想丢失本地数据库中的数据...

感谢

Hi,
I would like to know how to handle scope changes like adding/removing tables from a scope after the first synchronization ? 

For example, I have a scope with 2 tables : A and B. I do a synchronization between CE database (local) and SQL Server database (central) on this scope.
After, we add a new table C on the central database and we modify the table A (add new columns). And we want to synchronize again the central database with the local database.
What's the best practice to do this ? Create a new scope ? Modify the old scope ? we don't want to lose data on the local database ...

Thanks

推荐答案

你好，

对于新表（C）：您将要从头开始同步此表，这将导致在第一次同步时下载表C中的所有适用行。您可以通过将表C放在新范围内来实现此目的。

对于具有添加列（A）的表：您可能希望在服务器和客户端上添加列而不修改任何跟踪元数据。您要添加的列是否具有有效的默认值？
- Kyle

Hello,

For the new table (C): you will want to start synchronizing this table from scratch, this will cause all the applicable rows in table C to be downloaded on the first synchronization. You can acceive this by having table C in a new scope.

For the table with an added column (A): You would want to add the column on the server and client without modifying any tracking metadata. Does the column you are adding have a valid default value?
--
Kyle

这篇关于如何更改范围 - 同步V2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！