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.

adding a new replication site to an existing site

6 posts in Replication Last posting was on 2007-02-06 11:22:07.0Z
Paul Man Posted on 2007-01-25 12:55:58.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
Subject: adding a new replication site to an existing site
Date: Thu, 25 Jan 2007 12:55:58 -0000
Lines: 18
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45b8a817@solutions.advantagedatabase.com>
X-Trace: 25 Jan 2007 05:52:39 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:153
Article PK: 1134011

I just wanted to ask this seperately from my internet firewall question.

I have an existing site A operating and then I add a new site B that will
replicate new data up to A and take data down from A.
So my question is related to existing data from A down to B. If I create a
new blank database on B and create a publication from A to B, will the
existing data in A get replicated to B or will only new data changed in A
since the publication was created actually get replicated?

i.e. to create a new site do I have to backup and restore the existing
database or can I expect that if I were to publish everything on the
existing database that it would replicate all existing data on the new
database. This would possibly be equivalent to creating an initial snapshot
in MS SQL server.

Paul


Joachim Duerr (ADS) Posted on 2007-01-25 15:29:56.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: adding a new replication site to an existing site
Newsgroups: Advantage.Replication
References: <45b8a817@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <45b8ccf4@solutions.advantagedatabase.com>
Date: 25 Jan 2007 08:29:56 -0700
X-Trace: 25 Jan 2007 08:29:56 -0700, 130.214.79.11
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Replication:154
Article PK: 1134012


Paul Man wrote in <45b8a817@solutions.advantagedatabase.com>:

> So my question is related to existing data from A down to B. If I
> create a new blank database on B and create a publication from A to
> B, will the existing data in A get replicated to B or will only new
> data changed in A since the publication was created actually get
> replicated?

It will just distribute the data changes. You need to move a copy of
the database to the other server.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Paul Man Posted on 2007-01-26 16:15:35.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.Replication
References: <45b8a817@solutions.advantagedatabase.com> <45b8ccf4@solutions.advantagedatabase.com>
Subject: Re: adding a new replication site to an existing site
Date: Fri, 26 Jan 2007 16:15:35 -0000
Lines: 21
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45ba283c@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2007 09:11:40 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:157
Article PK: 1134014

Thanks.

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> wrote in message
news:45b8ccf4@solutions.advantagedatabase.com...
> Paul Man wrote in <45b8a817@solutions.advantagedatabase.com>:
>
>> So my question is related to existing data from A down to B. If I
>> create a new blank database on B and create a publication from A to
>> B, will the existing data in A get replicated to B or will only new
>> data changed in A since the publication was created actually get
>> replicated?
>
> It will just distribute the data changes. You need to move a copy of
> the database to the other server.
>
> --
> Joachim Duerr
> System Consultant (Advantage Database Server)
> Sybase iAnywhere
> advantagesupport[AT]ianywhere.com


Paul Man Posted on 2007-02-05 18:11:20.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
References: <45b8a817@solutions.advantagedatabase.com>
Subject: Re: adding a new replication site to an existing site
Date: Mon, 5 Feb 2007 18:11:20 -0000
Lines: 7
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45c7728c@solutions.advantagedatabase.com>
X-Trace: 5 Feb 2007 11:08:12 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:161
Article PK: 1134020

does replication insert missing records if I do an update on the source?
e.g. site A has several records missing. I run an update sql on site B on
the missing A records that are in B. The idea being to force them to update
and replicate. Will they then get inserted in A or will it generate an
error that they don't exist in the receiveing side?


Mark Wilkins Posted on 2007-02-06 00:38:18.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <45b8a817@solutions.advantagedatabase.com> <45c7728c@solutions.advantagedatabase.com>
Subject: Re: adding a new replication site to an existing site
Date: Mon, 5 Feb 2007 17:38:18 -0700
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45c7ccf4@solutions.advantagedatabase.com>
X-Trace: 5 Feb 2007 17:33:56 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:162
Article PK: 1134019

Hi Paul,

Currently it will generate an error if the target record does not exist. We
are planning on making this an option in the 9.0 release (still quite a ways
out). The plan is to provide an option (probably in the publication) that
indicates if the missing record should be inserted or not.

Mark Wilkins
Advantage R&D

"Paul Man" <paulman@datasoft.ie> wrote in message
news:45c7728c@solutions.advantagedatabase.com...
> does replication insert missing records if I do an update on the source?
> e.g. site A has several records missing. I run an update sql on site B on
> the missing A records that are in B. The idea being to force them to
> update and replicate. Will they then get inserted in A or will it
> generate an error that they don't exist in the receiveing side?
>
>


Paul Man Posted on 2007-02-06 11:22:07.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
References: <45b8a817@solutions.advantagedatabase.com> <45c7728c@solutions.advantagedatabase.com> <45c7ccf4@solutions.advantagedatabase.com>
Subject: Re: adding a new replication site to an existing site
Date: Tue, 6 Feb 2007 11:22:07 -0000
Lines: 33
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45c8640e@solutions.advantagedatabase.com>
X-Trace: 6 Feb 2007 04:18:38 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:163
Article PK: 1134022

In the mean time I could probably get round this by inserting the records
into a temporary table followed by deleting them from the source table and
subsequently inserting them back in to the original table - this should
force an insert in the destination replication.

A round about way but I'd imagine that would work.

"Mark Wilkins" <mark@no.email> wrote in message
news:45c7ccf4@solutions.advantagedatabase.com...
> Hi Paul,
>
> Currently it will generate an error if the target record does not exist.
> We are planning on making this an option in the 9.0 release (still quite a
> ways out). The plan is to provide an option (probably in the publication)
> that indicates if the missing record should be inserted or not.
>
> Mark Wilkins
> Advantage R&D
>
>
> "Paul Man" <paulman@datasoft.ie> wrote in message
> news:45c7728c@solutions.advantagedatabase.com...
>> does replication insert missing records if I do an update on the source?
>> e.g. site A has several records missing. I run an update sql on site B
>> on the missing A records that are in B. The idea being to force them to
>> update and replicate. Will they then get inserted in A or will it
>> generate an error that they don't exist in the receiveing side?
>>
>>
>
>