dotConnect for MySQL Documentation
Devart.Data.Synchronization Namespace / SyncTableProvisioning Class
Properties Methods

In This Topic
    SyncTableProvisioning Class Members
    In This Topic

    The following tables list the members exposed by SyncTableProvisioning.

    Public Properties
     NameDescription
    Public PropertyCreateProceduresDetermines whether to create a set of stored procedures that insert, update, and delete data and synchronization metadata.  
    Public PropertyCreateProceduresForAdditionalScopeDetermines whether to create sets of stored procedures that insert, update, and delete data and synchronization metadata for any additional scopes.  
    Public PropertyCreateTableDetermines whether to create the table that is synchronized.  
    Public PropertyCreateTrackingTableDetermines whether to create the table that store change-tracking metadata for the synchronized table.  
    Public PropertyCreateTriggersDetermines whether to create the triggers on the provisioned table, that update tracking the table.  
    Public PropertyFilterClauseGets or sets the filter condition (a WHERE clause without the WHERE keyword) to filter table data to be synchronized.  
    Public PropertyFilterColumnsGets the list of columns that are used for filtering data.  
    Public PropertyFilterParametersGets the collection of parameters, used for filtering and specified in the FilterClause property.  
    Public PropertyGlobalNameGets or sets the name, including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.  
    Public PropertyLocalNameGets or sets 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 preffix for names of Sync Framework metadata objects.  
    Public PropertyObjectSchemaGets or sets the schema containing Sync Framework metadata objects.  
    Public PropertyPopulateTrackingTableSpecifies whether to insert metadata into the change-tracking table for rows that already exist in the provisioned table. The default value is CreateOrUseExisting.  
    Public PropertySelectChangesProcNameGets or sets the name of the stored procedure that Sync Framework uses to select changes from a synchronized table during synchronization.  
    Public PropertyUnquotedGlobalNameGets or sets the name, not including database-specific delimiters, that other nodes in a synchronization topology use to identify a table.  
    Public PropertyUnquotedLocalNameGets or sets the name, not including database-specific delimiters, that the local node in a synchronization topology uses to identify a table.  
    Top
    Public Methods
     NameDescription
    Public MethodAddFilterColumnAdds a column that is used in the FilterClause to filter data rows for synchronization.  
    Public MethodApplyApplies the provisioning script to a database.  
    Public MethodScriptGenerates the SQL script to provision the table.  
    Public MethodToStringReturns a string that represents the SqlSyncTableProvisioning object.  
    Top
    See Also

    Reference

    SyncTableProvisioning Class
    Devart.Data.Synchronization Namespace

     

     

    © 2002 - 2024 Devart. All Rights Reserved.

    Send Feedback