SubscriptionSyncType Enumeration
Enumerates options for how the initial synchronization is performed for a subscription.
Espace de noms: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)
Syntaxe
'Déclaration
Public Enumeration SubscriptionSyncType
public enum SubscriptionSyncType
public enum class SubscriptionSyncType
public enum SubscriptionSyncType
public enum SubscriptionSyncType
Members
| Member name | Description |
|---|---|
| Automatic | Schema and initial data for published tables are transferred to the Subscriber when the initial snapshot is applied. |
| InitializeWithBackup | Schema and initial data for published tables are obtained from a backup of the publication database. This option assumes that the Subscriber has access to a backup of the publication database. This option is only supported for transactional publications. The location of the backup and media type for the backup are specified by BackupDeviceName and BackupDeviceType. When using this option, a peer-to-peer transactional replication topology need not be quiesced during configuration. This option is not supported for subscriptions to non-SQL Server publications. This option is only available for SQL Server 2005 and later. |
| None | Subscriber already has the schema and initial data for published tables. This option is supported for merge publications. This option has been deprecated for transactional publications. Use ReplicationSupportOnly instead. |
| ReplicationSupportOnly | Provides automatic generation at the Subscriber of article custom stored procedures and triggers that support updating subscriptions. This option is supported only for transactional publications. This option assumes that Subscriber already has the schema and initial data for published tables. When configuring a peer-to-peer transactional replication topology, ensure that the data at all nodes in the topology is identical. Quiesce the replication topology before configuring peer-to-peer transactional replication using this option. This option is only available for SQL Server 2005 and later. |
Notes
System tables and data are always transferred.
This namespace, class, or member is supported only in version 2.0 of the .NET Framework.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
Microsoft.SqlServer.Replication Namespace
MergePullSubscription Class
MergePublication.MakePullSubscriptionWellKnown Method
Autres ressources
Procédure : créer un abonnement par extraction de données (pull) (programmation RMO)