SqlSyncTableProvisioning Class
Represents the provisioning of a SQL Server database table that is represented by a DbSyncTableDescription object.
Assembly: Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)
The SqlSyncTableProvisioning type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | SqlSyncTableProvisioning(DbSyncTableDescription) | Obsolete. Initializes a new instance of the SqlSyncTableProvisioning class for the specified table. |
![]() | SqlSyncTableProvisioning(SqlConnection, DbSyncTableDescription) | Initializes a new instance of the SqlSyncTableProvisioning class for the specified connection and table schema. |
![]() | SqlSyncTableProvisioning(DbSyncTableDescription, String) | Obsolete. Initializes a new instance of the SqlSyncTableProvisioning class for the specified table and synchronization object prefix. |
| Name | Description | |
|---|---|---|
![]() | CreateProcedures | Gets or sets whether to create a set of stored procedures that insert, update, and delete data and synchronization metadata. |
![]() | CreateProceduresForAdditionalScope | Gets or sets whether to create, for any additional scopes, sets of stored procedures that insert, update, and delete data and synchronization metadata. |
![]() | CreateTable | Gets or sets whether to create a base table. |
![]() | CreateTrackingTable | Gets or sets whether to create a table that stores change-tracking metadata for the base table. |
![]() | CreateTriggers | Gets or sets whether to create triggers on the base table that update to the tracking table. |
![]() | FilterClause | Gets or sets the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table. |
![]() | FilterColumns | Gets the list of columns that were added by using AddFilterColumn. |
![]() | FilterParameters | Gets the list of filter parameters that are used to control which items are enumerated. |
![]() | GlobalName | Gets the name, including database-specific delimiters, that other nodes in a synchronization topology use to identify a table. |
![]() | LocalName | Gets the name, including database-specific delimiters, that the local node in a synchronization topology uses to identify a table. |
![]() | ObjectPrefix | Gets or sets the optional prefix that is used to identify objects that Sync Framework creates. |
![]() | ObjectSchema | Gets or sets the database schema in which Sync Framework creates objects. |
![]() | PopulateTrackingTable | Gets or sets whether to insert metadata into the change-tracking table for rows that already exist in the base table. |
![]() | UnquotedGlobalName | Gets the name, not including database-specific delimiters, that other nodes in a synchronization topology use to identify a table. |
![]() | UnquotedLocalName | Gets the name, not including database-specific delimiters, that the local node in a synchronization topology uses to identify a table. |
![]() | UseBulkProcedures | Gets or sets a value that indicates whether the bulk procedures should be created during provisioning. |
| Name | Description | |
|---|---|---|
![]() | AddFilterColumn | Adds a column that is used in the filter clause that is specified in FilterClause. |
![]() | Apply | Applies the provisioning script to a SQL Server database over the connection specified when this object was constructed. |
![]() | Apply(SqlConnection) | Obsolete. Applies the provisioning script to a SQL Server database over the specified connection. |
![]() | Apply(SqlTransaction) | Applies the provisioning script to a SQL Server database within the specified transaction. |
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | Script | Generates a string that contains the SQL code to provision a table for a particular scope. |
![]() | ToString | Returns a string that represents the SqlSyncTableProvisioning object. (Overrides Object.ToString.) |
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).
Show:
