SqlSyncScopeProvisioning Methods

Include Protected Members
Include Inherited Members

The SqlSyncScopeProvisioning type exposes the following members.

Methods

  Name Description
Public method Apply() Applies the provisioning script to a SQL Server database by using the connection that was specified in the constructor.
Public method Apply(SqlConnection) Obsolete. Applies the provisioning script to a SQL Server database over the specified connection.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method PopulateFromScopeDescription Sets the scope description from which the database should be provisioned.
Public method PopulateFromTemplate Sets the template-based scope description from which the database should be provisioned.
Public method ScopeExists(String) Indicates whether the specified scope exists in the database by using the connection that was specified in the constructor.
Public method ScopeExists(String, SqlConnection) Obsolete. Returns whether the specified scope exists.
Public method Script() Generates a string that contains the SQL code to provision the database for a particular scope by using the connection that was specified in the constructor.
Public method Script(String) Obsolete. Generates a string that contains the SQL code to provision the database for a particular scope.
Public method SetCreateProceduresDefault Sets whether to create a set of stored procedures that insert, update, and delete data and synchronization metadata. The default setting is CreateOrUseExisting.
Public method SetCreateProceduresForAdditionalScopeDefault Sets whether to create additional stored procedures for a scope that contains tables that have already been provisioned for other scopes. For example, this scope adds a filter column to a table that has already been provisioned without the filter column. Set this option to Create to ensure that an additional change enumeration procedure is created that can handle the filter column. The default setting is Skip.
Public method SetCreateTableDefault Sets whether to create base tables when a scope is configured. Base tables are tables that contain user data, as opposed to tracking tables that contain synchronization metadata. The default setting is CreateOrUseExisting.
Public method SetCreateTrackingTableDefault Sets whether to create tables that store change-tracking metadata. The default setting is CreateOrUseExisting.
Public method SetCreateTriggersDefault Sets whether to create, on base tables, triggers that update tracking tables. The default setting is CreateOrUseExisting.
Public method SetPopulateTrackingTableDefault Sets whether to insert metadata into change-tracking tables for rows that already exist in base tables. The default setting is CreateOrUseExisting.
Public method SetUseBulkProceduresDefault Sets a value that indicates whether bulk procedures should be created when provisioning stored procedures. The default setting is true when provisioning a SQL Server 2008 or SQL Azure database; otherwise, it is false.
Public method TemplateExists Returns whether the specified template exists in the database.
Public method ToString (Inherited from Object.)

Top

See Also

Reference

SqlSyncScopeProvisioning Class

Microsoft.Synchronization.Data.SqlServer Namespace