MSDN Library

SqlSyncTableProvisioning Class

Represents the provisioning of a SQL Server database table that is represented by a DbSyncTableDescription object.

System.Object
  Microsoft.Synchronization.Data.SqlServer.SqlSyncTableProvisioning

Namespace:  Microsoft.Synchronization.Data.SqlServer
Assembly:  Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)

public class SqlSyncTableProvisioning

The SqlSyncTableProvisioning type exposes the following members.

  NameDescription
Public methodSqlSyncTableProvisioning(DbSyncTableDescription) Obsolete. Initializes a new instance of the SqlSyncTableProvisioning class for the specified table.
Public methodSqlSyncTableProvisioning(SqlConnection, DbSyncTableDescription)Initializes a new instance of the SqlSyncTableProvisioning class for the specified connection and table schema.
Public methodSqlSyncTableProvisioning(DbSyncTableDescription, String) Obsolete. Initializes a new instance of the SqlSyncTableProvisioning class for the specified table and synchronization object prefix.
Top

  NameDescription
Public propertyCreateProceduresGets or sets whether to create a set of stored procedures that insert, update, and delete data and synchronization metadata.
Public propertyCreateProceduresForAdditionalScopeGets or sets whether to create, for any additional scopes, sets of stored procedures that insert, update, and delete data and synchronization metadata.
Public propertyCreateTableGets or sets whether to create a base table.
Public propertyCreateTrackingTableGets or sets whether to create a table that stores change-tracking metadata for the base table.
Public propertyCreateTriggersGets or sets whether to create triggers on the base table that update to the tracking table.
Public propertyFilterClauseGets or sets the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.
Public propertyFilterColumnsGets the list of columns that were added by using AddFilterColumn.
Public propertyFilterParametersGets the list of filter parameters that are used to control which items are enumerated.
Public propertyGlobalNameGets the name, including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.
Public propertyLocalNameGets the name, including database-specific delimiters, that the local node in a synchronization topology uses to identify a table.
Public propertyObjectPrefixGets or sets the optional prefix that is used to identify objects that Sync Framework creates.
Public propertyObjectSchemaGets or sets the database schema in which Sync Framework creates objects.
Public propertyPopulateTrackingTableGets or sets whether to insert metadata into the change-tracking table for rows that already exist in the base table.
Public propertyUnquotedGlobalNameGets the name, not including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.
Public propertyUnquotedLocalNameGets the name, not including database-specific delimiters, that the local node in a synchronization topology uses to identify a table.
Public propertyUseBulkProceduresGets or sets a value that indicates whether the bulk procedures should be created during provisioning.
Top

  NameDescription
Public methodAddFilterColumnAdds a column that is used in the filter clause that is specified in FilterClause.
Public methodApply()Applies the provisioning script to a SQL Server database over the connection specified when this object was constructed.
Public methodApply(SqlConnection) Obsolete. Applies the provisioning script to a SQL Server database over the specified connection.
Public methodApply(SqlTransaction)Applies the provisioning script to a SQL Server database within the specified transaction.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodScriptGenerates a string that contains the SQL code to provision a table for a particular scope.
Public methodToStringReturns a string that represents the SqlSyncTableProvisioning object. (Overrides Object.ToString().)
Top

Provisioning can occur at the level of the table, but it typically occurs at the level of the scope, which is a logical grouping of tables. For more information, see How To: Execute Database Synchronization (SQL Server).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2016 Microsoft