SqlSyncScopeProvisioning.SetCreateTableDefault 方法

  • 项目

设置当配置作用域时是否创建基表。

命名空间: Microsoft.Synchronization.Data.SqlServer
程序集: Microsoft.Synchronization.Data.SqlServer（在 microsoft.synchronization.data.sqlserver.dll 中）

语法

声明
Public Sub SetCreateTableDefault ( _
    defaultOption As DbSyncCreationOption _
)
用法
Dim instance As SqlSyncScopeProvisioning
Dim defaultOption As DbSyncCreationOption

instance.SetCreateTableDefault(defaultOption)

public void SetCreateTableDefault (
    DbSyncCreationOption defaultOption
)

public:
void SetCreateTableDefault (
    DbSyncCreationOption defaultOption
)

public void SetCreateTableDefault (
    DbSyncCreationOption defaultOption
)

public function SetCreateTableDefault (
    defaultOption : DbSyncCreationOption
)

参数

备注

如果数据库中已存在这些基表，并且您不使用 DbSyncTableDescription 对象来定义任何表架构，请指定 Skip 的值。

示例

下面的代码示例为 filtered_customer 作用域创建一个设置对象，指定基表不应在服务器数据库中创建，并且指定与同步相关的所有对象都应在名为 "Sync" 的数据库架构中创建。作为作用域设置的一部分，该代码对 Customer 表定义一个筛选器。将只同步与该筛选器匹配的行。没有对 CustomerContact 表定义任何筛选器；因此，将同步来自该表的所有行。在定义设置选项后，调用 Apply 方法以便在服务器数据库中创建变更跟踪基础结构；并且设置脚本将写入某一文件。若要在完整示例上下文中查看此代码，请参见如何配置和执行协作同步 (SQL Server)。

SqlSyncScopeProvisioning serverConfig = new SqlSyncScopeProvisioning(scopeDesc);
serverConfig.SetCreateTableDefault(DbSyncCreationOption.Skip);
serverConfig.ObjectSchema = "Sync";

// Specify which column(s) in the Customer table to use for filtering data, 
// and the filtering clause to use against the tracking table.
// "[side]" is an alias for the tracking table.
serverConfig.Tables["Sales.Customer"].AddFilterColumn("CustomerType");
serverConfig.Tables["Sales.Customer"].FilterClause = "[side].[CustomerType] = 'Retail'";

// Configure the scope and change-tracking infrastructure.
serverConfig.Apply(serverConn);

// Write the configuration script to a file. You can modify 
// this script if necessary and run it against the server
// to customize behavior.
File.WriteAllText("SampleConfigScript.txt",
    serverConfig.Script("SyncSamplesDb_SqlPeer1"));

Dim serverConfig As New SqlSyncScopeProvisioning(scopeDesc)
serverConfig.SetCreateTableDefault(DbSyncCreationOption.Skip)
serverConfig.ObjectSchema = "Sync"

' Specify which column(s) in the Customer table to use for filtering data, 
' and the filtering clause to use against the tracking table. 
' "[side]" is an alias for the tracking table. 
serverConfig.Tables("Sales.Customer").AddFilterColumn("CustomerType")
serverConfig.Tables("Sales.Customer").FilterClause = "[side].[CustomerType] = 'Retail'"

' Configure the scope and change-tracking infrastructure. 
serverConfig.Apply(serverConn)

' Write the configuration script to a file. You can modify 
' this script if necessary and run it against the server 
' to customize behavior. 
File.WriteAllText("SampleConfigScript.txt", serverConfig.Script("SyncSamplesDb_SqlPeer1"))

请参阅

参考

SqlSyncScopeProvisioning 类
SqlSyncScopeProvisioning 成员
Microsoft.Synchronization.Data.SqlServer 命名空间