<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: repl_server_rename - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: repl_server_rename - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: repl_server_rename - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_repl_server_rename" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - repl_server_rename</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_repl_server.html" title="REPL_SERVER">Prev</a> | <a class="link" href="fn_repl_stat.html" title="REPL_STAT">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a class="selected" href="functions.html#repl">Replication</a>
</div>
<div class="selected">
<div>
<a href="fn_rdf_repl_graph_del.html">rdf_repl_graph_del</a>
</div>
<div>
<a href="fn_rdf_repl_graph_ins.html">rdf_repl_graph_ins</a>
</div>
<div>
<a href="fn_rdf_repl_start.html">rdf_repl_start</a>
</div>
<div>
<a href="fn_REPL_ADD_CR.html">repl_add_cr</a>
</div>
<div>
<a href="fn_REPL_ADD_DAV_CR.html">repl_add_dav_cr</a>
</div>
<div>
<a href="fn_REPL_ADD_SNAPSHOT_CR.html">repl_add_snapshot_cr</a>
</div>
<div>
<a href="fn_REPL_CREATE_SNAPSHOT_PUB.html">repl_create_snapshot...</a>
</div>
<div>
<a href="fn_REPL_CREATE_SNAPSHOT_SUB.html">repl_create_snapshot...</a>
</div>
<div>
<a href="fn_REPL_DROP_SNAPSHOT_PUB.html">repl_drop_snapshot_p...</a>
</div>
<div>
<a href="fn_REPL_DROP_SNAPSHOT_SUB.html">repl_drop_snapshot_s...</a>
</div>
<div>
<a href="fn_repl_grant.html">repl_grant</a>
</div>
<div>
<a href="fn_repl_init_copy.html">repl_init_copy</a>
</div>
<div>
<a href="fn_REPL_INIT_SNAPSHOT.html">repl_init_snapshot</a>
</div>
<div>
<a href="fn_repl_publish.html">repl_publish</a>
</div>
<div>
<a href="fn_repl_pub_add.html">repl_pub_add</a>
</div>
<div>
<a href="fn_repl_pub_init_image.html">repl_pub_init_image</a>
</div>
<div>
<a href="fn_repl_pub_remove.html">repl_pub_remove</a>
</div>
<div>
<a href="fn_repl_revoke.html">repl_revoke</a>
</div>
<div>
<a href="fn_repl_sched_init.html">repl_sched_init</a>
</div>
<div>
<a href="fn_repl_server.html">repl_server</a>
</div>
<div>
<a href="fn_REPL_SERVER_NAME.html">repl_server_name</a>
</div>
<div>
<a href="fn_REPL_SNP_SERVER.html">repl_snp_server</a>
</div>
<div>
<a href="fn_repl_stat.html">repl_stat</a>
</div>
<div>
<a href="fn_repl_subscribe.html">repl_subscribe</a>
</div>
<div>
<a href="fn_repl_unpublish.html">repl_unpublish</a>
</div>
<div>
<a href="fn_repl_unsubscribe.html">repl_unsubscribe</a>
</div>
<div>
<a href="fn_REPL_UPDATE_SNAPSHOT.html">repl_update_snapshot</a>
</div>
<div>
<a href="fn_repl_disconnect.html">repl_disconnect</a>
</div>
<div>
<a href="fn_repl_new_log.html">repl_new_log</a>
</div>
<div>
<a href="fn_repl_purge.html">repl_purge</a>
</div>
<div>
<a class="selected" href="fn_repl_server_rename.html">repl_server_rename</a>
</div>
<div>
<a href="fn_repl_status.html">repl_status</a>
</div>
<div>
<a href="fn_repl_sync.html">repl_sync</a>
</div>
<div>
<a href="fn_repl_sync_all.html">repl_sync_all</a>
</div>
<div>
<a href="fn_repl_text.html">repl_text</a>
</div>
<div>
<a href="fn_repl_this_server.html">repl_this_server</a>
</div>
<div>
<a href="fn_sub_schedule.html">sub_schedule</a>
</div>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>repl_server_rename</h2>
<div class="refpurpose">rename the publishing server instance</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">repl_server_rename</span>
</span>
(<span class="paramdef">in <span class="parameter">old_name</span>varchar</span>,
<span class="paramdef">in <span class="parameter">new_name</span>varchar</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>
This function is useful to rename the publishing servers data (that stored
in to the replication tables) after renaming the server in virtuoso.ini file.
The call of the procedure will associate the all data belong to the old server
name to the current server name. It will also set the appropriate transaction
levels. In case of duplicate publications (publications with the same name
exists in old and new server definitions) it will reject the operation.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">old_name – </span>
The old name of the publishing server.</div>
<div class="refsect2">
<span class="refsect2title">new_name – </span>
The new name of the publishing server (must be the same as ServerName from Replication section of INI file).</div>
</div>
<div class="refsect1">
<div class="refsect1title">Example</div>
<a name="ex_repl_server_rename_1" />
<div class="example">
<div class="exampletitle">Renaming of the existing publisher server</div>
<p>An existing publisher 'demo-pub' server is renamed to the 'working-pub'.
In order to update the subscriber descriptions we MUST issue the following:</p>
<div>
<pre class="screen">
SQL> DB.DBA.REPL_SERVER_RENAME ('demo-pub', 'working-pub');
</pre>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_sub_schedule.html">sub_schedule()</a>
</p>
<p>
<a href="fn_repl_disconnect.html">repl_disconnect()</a>
</p>
<p>
<a href="fn_repl_grant.html">repl_grant()</a>
</p>
<p>
<a href="fn_repl_init_copy.html">repl_init_copy()</a>
</p>
<p>
<a href="fn_repl_new_log.html">repl_new_log()</a>
</p>
<p>
<a href="fn_repl_pub_add.html">repl_pub_add()</a>
</p>
<p>
<a href="fn_repl_pub_init_image.html">repl_pub_init_image()</a>
</p>
<p>
<a href="fn_repl_pub_remove.html">repl_pub_remove()</a>
</p>
<p>
<a href="fn_repl_publish.html">repl_publish()</a>
</p>
<p>
<a href="fn_repl_revoke.html">repl_revoke()</a>
</p>
<p>
<a href="fn_repl_sched_init.html">repl_sched_init()</a>
</p>
<p>
<a href="fn_repl_server.html">repl_server()</a>
</p>
<p>
<a href="fn_repl_stat.html">repl_stat()</a>
</p>
<p>
<a href="fn_repl_status.html">repl_status()</a>
</p>
<p>
<a href="fn_repl_subscribe.html">repl_subscribe()</a>
</p>
<p>
<a href="fn_repl_sync.html">repl_sync()</a>
</p>
<p>
<a href="fn_repl_sync_all.html">repl_sync_all()</a>
</p>
<p>
<a href="fn_repl_text.html">repl_text()</a>
</p>
<p>
<a href="fn_repl_this_server.html">repl_this_server()</a>
</p>
<p>
<a href="fn_repl_unpublish.html">repl_unpublish()</a>
</p>
<p>
<a href="fn_repl_unsubscribe.html">repl_unsubscribe()</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
496
