SqlSyncTableProvisioning Members

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
Public method SqlSyncTableProvisioning Overloaded. Initializes a new instance of the SqlSyncTableProvisioning class.

Top

Public Properties

  Name Description
Public property CreateProcedures Gets or sets whether to create a set of stored procedures that insert, update, and delete data and synchronization metadata.
Public property CreateProceduresForAdditionalScope Gets or sets whether to create for any additional scopes sets of stored procedures that insert, update, and delete data and synchronization metadata.
Public property CreateTable Gets or sets whether to create a base table.
Public property CreateTrackingTable Gets or sets whether to create a table that stores change-tracking metadata for the base table.
Public property CreateTriggers Gets or sets whether to create on the base table triggers that update the tracking table.
Public property FilterClause Gets or sets the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.
Public property FilterColumns Gets the list of columns that were added by using AddFilterColumn.
Public property GlobalName Gets the name, including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.
Public property LocalName Gets the name, including database-specific delimiters, that the local node in a synchronization topology uses to identify a table.
Public property ObjectPrefix Gets or sets the optional prefix that is used to identify objects that Sync Framework creates.
Public property ObjectSchema Gets or sets the database schema in which Sync Framework creates objects.
Public property PopulateTrackingTable Gets or sets whether to insert metadata into the change-tracking table for rows that already exist in the base table.
Public property UnquotedGlobalName Gets the name, not including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.
Public property 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
Public method AddFilterColumn Adds a column that is used in the filter clause that is specified in FilterClause.
Public method Apply Overloaded. Applies the provisioning script to a SQL Server database.
Public method Equals  Overloaded. (Inherited from Object.)
Public method GetHashCode  (Inherited from Object.)
Public method GetType  (Inherited from Object.)
Public method Dd937811.static(en-us,SQL.105).gif ReferenceEquals  (Inherited from Object.)
Public method Script Generates a string that contains the SQL code to provision a table for a particular scope.
Public method ToString Overridden. Returns a string that represents the SqlSyncTableProvisioning object.

Top

Protected Methods

  Name Description
Protected method Finalize  (Inherited from Object.)
Protected method MemberwiseClone  (Inherited from Object.)

Top

See Also

Reference

SqlSyncTableProvisioning Class
Microsoft.Synchronization.Data.SqlServer Namespace