Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

database rep def vs warm standby with sp_setreptable

2 posts in General Discussion Last posting was on 2011-07-07 19:50:19.0Z
vtpcnk Posted on 2011-07-07 06:16:01.0Z
Sender: 2280.4e13e6ce.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.rep-server
Subject: database rep def vs warm standby with sp_setreptable
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e154f21.6985.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jul 2011 23:16:01 -0700
X-Trace: forums-1-dub 1310019361 10.22.241.41 (6 Jul 2011 23:16:01 -0700)
X-Original-Trace: 6 Jul 2011 23:16:01 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8977
Article PK: 870154

we have two dbs setup as a warm standby.

on the primary the db is NOT configured for sp_reptostandby.

instead individual tables are marked for replication using
sp_setreptable and each table has its rep defs - but without
subscriptions on the standby.

now we want to replicate the entire db to another db.

normally we would simply create subs for the target db with
the existing rep defs.

but the question is : on the primary db, on top of all the
sp_setreptable, can we create a database level replication
with 'create database replication definition' and use that
to replicate the entire db to the new target db?

appreciate any insights.


"Mark A. Parsons" <iron_horse Posted on 2011-07-07 19:50:19.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: database rep def vs warm standby with sp_setreptable
References: <4e154f21.6985.1681692777@sybase.com>
In-Reply-To: <4e154f21.6985.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e160dfb$1@forums-1-dub>
Date: 7 Jul 2011 12:50:19 -0700
X-Trace: forums-1-dub 1310068219 10.22.241.152 (7 Jul 2011 12:50:19 -0700)
X-Original-Trace: 7 Jul 2011 12:50:19 -0700, vip152.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8982
Article PK: 870163

I haven't actually tried that combination but I'm thinking it should be doable ... when in doubt, try it out!

Since the PDB is already defined as the active db in a warm standby logical pair, you'll want to reference the logical
db name in the 'create database repdef' command. This should also insure that after performing a warm standby switch
command that the new PDB ('old' RDB) continues to feed your database repdef.

On 07/07/2011 02:16, vtpcnk wrote:
> we have two dbs setup as a warm standby.
>
> on the primary the db is NOT configured for sp_reptostandby.
>
> instead individual tables are marked for replication using
> sp_setreptable and each table has its rep defs - but without
> subscriptions on the standby.
>
> now we want to replicate the entire db to another db.
>
> normally we would simply create subs for the target db with
> the existing rep defs.
>
> but the question is : on the primary db, on top of all the
> sp_setreptable, can we create a database level replication
> with 'create database replication definition' and use that
> to replicate the entire db to the new target db?
>
> appreciate any insights.