sp_addpublication |
Ajout de publication |
|---|---|
| SQL Server | |
Syntaxe
|
sp_addpublication [ @publication = ] 'publication' [ , [ @taskid = ] tasked ] [ , [ @restricted = ] 'restricted' ] [ , [ @sync_method = ] 'sync_method' ] [ , [ @repl_freq = ] 'repl_freq' ] [ , [ @description = ] 'description' ] [ , [ @status = ] 'status' ] [ , [ @independent_agent = ] 'independent_agent' ] [ , [ @immediate_sync = ] 'immediate_sync' ] [ , [ @enabled_for_internet = ] 'enabled_for_internet' ] [ , [ @allow_push = ] 'allow_push' [ , [ @allow_pull = ] 'allow_pull' ] [ , [ @allow_anonymous = ] 'allow_anonymous' ] [ , [ @allow_sync_tran = ] 'allow_sync_tran' ] [ , [ @autogen_sync_procs = ] 'autogen_sync_procs' ] [ , [ @retention = ] retention ] [ , [ @allow_queued_tran= ] 'allow_queued_updating' ] [ , [ @snapshot_in_defaultfolder= ] 'snapshot_in_default_folder' ] [ , [ @alt_snapshot_folder= ] 'alternate_snapshot_folder' ] [ , [ @pre_snapshot_script= ] 'pre_snapshot_script' ] [ , [ @post_snapshot_script= ] 'post_snapshot_script' ] [ , [ @compress_snapshot= ] 'compress_snapshot' ] [ , [ @ftp_address = ] 'ftp_address' ] [ , [ @ftp_port= ] ftp_port ] [ , [ @ftp_subdirectory = ] 'ftp_subdirectory' ] [ , [ @ftp_login = ] 'ftp_login' ] [ , [ @ftp_password = ] 'ftp_password' ] [ , [ @allow_dts = ] 'allow_dts' ] [ , [ @allow_subscription_copy = ] 'allow_subscription_copy' ] [ , [ @conflict_policy = ] 'conflict_policy' ] [ , [ @centralized_conflicts = ] 'centralized_conflicts' ] [ , [ @conflict_retention = ] conflict_retention ] [ , [ @queue_type = ] 'queue_type' ] [ , [ @add_to_active_directory = ] 'add_to_active_directory' ] [ , [ @logreader_job_name = ] 'logreader_agent_name' ] [ , [ @qreader_job_name = ] 'queue_reader_agent_name' ] [ , [ @publisher = ] 'publisher' ] [ , [ @allow_initialize_from_backup = ] 'allow_initialize_from_backup' ] [ , [ @replicate_ddl = ] replicate_ddl ] [ , [ @enabled_for_p2p = ] 'enabled_for_p2p' ] [ , [ @publish_local_changes_only = ] 'publish_local_changes_only' ] [ , [ @enabled_for_het_sub = ] 'enabled_for_het_sub' ] [ , [ @p2p_conflictdetection = ] 'p2p_conflictdetection' ] [ , [ @p2p_originator_id = ] p2p_originator_id [ , [ @p2p_continue_onconflict = ] 'p2p_continue_onconflict' [ , [ @allow_partition_switch = ] 'allow_partition_switch' [ , [ @replicate_partition_switch = ]'replicate_partition_switch' |
Description
Cette Stored Procedure permet de créer un instantané ou une publication transactionnelle. Cette STORED PROCEDURE est exécutée au niveau du Publisher sur la base de données de publication.
Dernière mise à jour : Dimanche, le 29 Août 2021