Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Represents the provisioning of a SQL Server database table that is represented by a DbSyncTableDescription object.
The following tables list the members exposed by the SqlSyncTableProvisioning type.
Public Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
SqlSyncTableProvisioning | Overloaded. Initializes a new instance of the SqlSyncTableProvisioning class. |
Top
Public Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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 on the base table triggers that update 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. |
|
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. |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
|
AddFilterColumn | Adds a column that is used in the filter clause that is specified in FilterClause. |
|
Apply | Overloaded. Applies the provisioning script to a SQL Server database. |
|
Equals | Overloaded. (Inherited from Object.) |
|
GetHashCode | (Inherited from Object.) |
|
GetType | (Inherited from Object.) |
.gif "Dd937811.static(en-us,SQL.105).gif") |
ReferenceEquals | (Inherited from Object.) |
|
Script | Generates a string that contains the SQL code to provision a table for a particular scope. |
|
ToString | Overridden. Returns a string that represents the SqlSyncTableProvisioning object. |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
MemberwiseClone | (Inherited from Object.) |
Top
See Also
Reference
SqlSyncTableProvisioning Class
Microsoft.Synchronization.Data.SqlServer Namespace