# 22. Virtuoso Functions Guide - REPL_SNP_SERVER

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
repl_add_cr
repl_add_dav_cr
repl_add_snapshot_cr
repl_create_snapshot...
repl_create_snapshot...
repl_drop_snapshot_p...
repl_drop_snapshot_s...
repl_grant
repl_init_copy
repl_init_snapshot
repl_publish
repl_pub_add
repl_pub_init_image
repl_pub_remove
repl_revoke
repl_sched_init
repl_server
repl_server_name
repl_snp_server
repl_stat
repl_subscribe
repl_unpublish
repl_unsubscribe
repl_update_snapshot
repl_disconnect
repl_new_log
repl_purge
repl_server_rename
repl_status
repl_sync
repl_sync_all
repl_text
repl_this_server
sub_schedule
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## REPL_SNP_SERVER

Define bi-directional snapshot replication server name
varchar REPL_SNP_SERVER (in dsn varchar, in uid varchar, in pwd varchar);
Description

This function should be used to define a server for bi-directional snapshot replication.

Parameters
dsn – Dsn is a data source name.
uid – Uid is data source user name.
pwd – Uid is data source password.
Return Types

REPL_SNP_SERVER() returns remote server name which can be used in calls to REPL_CREATE_SNAPSHOT_SUB(), REPL_DROP_SNAPSHOT_SUB() and REPL_INIT_SNAPSHOT_SUB() functions.

Examples
Defining bi-directional snapshot replication server

The following statement defines bi-directional replication server for server with DSN 'localhost:1121':

    SQL> REPL_SNP_SERVER ('localhost:1121', 'dba', 'dba');

See Also

REPL_CREATE_SNAPSHOT_SUB()

REPL_CREATE_SNAPSHOT_PUB()

REPL_DROP_SNAPSHOT_SUB()

REPL_DROP_SNAPSHOT_PUB()

REPL_INIT_SNAPSHOT()

REPL_DROP_SNAPSHOT_PUB()

REPL_SERVER_NAME()