Name

REPL_SUBSCRIBE — add a subscription

Synopsis

REPL_SUBSCRIBE ( in server_name varchar ,
  in publication varchar ,
  in dav_user varchar ,
  in dav_group varchar ,
  in replication_user varchar ,
  in replication_password varchar ,
  in sync_user varchar );
 

Description

This function is used to subscribe to an existing publication, and to specify the local WebDAV owner for replicated WebDAV content. Before making a subscription the repl_server() function must be called in order to define the publishing server. After making a subscription it becomes off-line awaiting synchronization from a scheduled task or call to the repl_sync() function. Also the initial data of the subscription will be not loaded until repl_init_copy() is called or the initial image has been loaded.

Parameters

server_name

target publisher server name.

publication

publication account name.

dav_user

A valid local WebDAV user account name that will own local copy. If this is null 'REPLICATION' user account will be created that will be disabled by default.

dav_group

A valid local WebDAV group name to own the local copy.

replication_user

Is used for authentication on the publisher. This should be a valid DB account on publisher.

replication_password

Is used for authentication on the publisher. This should be valid password for replication_user on publisher.

sync_user

A local DB account used to replay replication feeds.

Example

Example 24.333. Subscribing to a publication

This example shows making a subscription to the 'table_publication' published on a 'demo-srv' server. The WebDAV items will belong to the WebDAV administrator.

SQL> DB.DBA.REPL_SUBSCRIBE ('demo-srv','demo-publication', 'dav', 'dav', 'demo', 'demo');