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.

replicate multiple servers to one

7 posts in Replication Last posting was on 2009-01-30 15:37:20.0Z
Dirk Verleyen Posted on 2009-01-22 15:35:56.0Z
Date: Thu, 22 Jan 2009 16:35:56 +0100
From: Dirk Verleyen <dirk.verleyennospam@carfac.be>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: replicate multiple servers to one
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.83.111.86
Message-ID: <4978926e@solutions.advantagedatabase.com>
X-Trace: 22 Jan 2009 08:36:14 -0700, 81.83.111.86
Lines: 18
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.83.111.86
Xref: solutions.advantagedatabase.com Advantage.Replication:342
Article PK: 1134196

Hi all,

I'm thinking about setting up the following:

We have multiple clients who are using ADS.
Some off them want to feed a webshop using the data stored in ADT Tables.

Not all off them want to host their own website.

Since our company has everything to host this, I was thinking about
hosting the websites here.

Is it possible to replicate some tables from the customer his server to
our server?
That way I can feed the customers webshop using their own replicated
data here.

Thanks.


Peter Funk (ADS) Posted on 2009-01-22 16:14:36.0Z
Date: Thu, 22 Jan 2009 16:14:36 +0000 (UTC)
Message-ID: <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: replicate multiple servers to one
Newsgroups: Advantage.Replication
References: <4978926e@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 22 Jan 2009 09:14:17 -0700, 10.24.38.185
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:343
Article PK: 1134198

Hello Dirk,
Advantage replication can certainly accomplish what you describe. You would
need to purchase replication licenses for each client ADS server you want
to replicate to your office. You'd also need an ADS server at your office
running to accept the updates. This server wouldn't need the replication
license unless you want to replicate from it to another server. Also, one
ADS server at your office would suffice as long as it has enough user licenses
to handle updates comming in from each of your customers. You should only
need one user license for each customer server.

One thing to note is that replication requires the use of a data dictionary,
both at the client server and at your office server. Whatever method you
plan to use to publish their data to a website would need to connect to the
data dictionary to get the data.

Regards,
Peter Funk
Advantage R&D


Dirk Verleyen Posted on 2009-01-23 07:39:38.0Z
Date: Fri, 23 Jan 2009 08:39:38 +0100
From: Dirk Verleyen <dirk.verleyennospam@carfac.be>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: Re: replicate multiple servers to one
References: <4978926e@solutions.advantagedatabase.com> <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com>
In-Reply-To: <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 217.136.183.58
Message-ID: <4979744b@solutions.advantagedatabase.com>
X-Trace: 23 Jan 2009 00:39:55 -0700, 217.136.183.58
Lines: 29
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.136.183.58
Xref: solutions.advantagedatabase.com Advantage.Replication:344
Article PK: 1134199

Peter Funk (ADS) schreef:

> Hello Dirk,
> Advantage replication can certainly accomplish what you describe. You
> would need to purchase replication licenses for each client ADS server
> you want to replicate to your office. You'd also need an ADS server at
> your office running to accept the updates. This server wouldn't need
> the replication license unless you want to replicate from it to another
> server. Also, one ADS server at your office would suffice as long as it
> has enough user licenses to handle updates comming in from each of your
> customers. You should only need one user license for each customer server.
>
> One thing to note is that replication requires the use of a data
> dictionary, both at the client server and at your office server.
> Whatever method you plan to use to publish their data to a website would
> need to connect to the data dictionary to get the data.
>
> Regards,
> Peter Funk
> Advantage R&D
>
>

Hi Peter,

Could you tell me what a replication licence would cost?

We are already using a Data Dictionary for all our customers, so no prob.

Thanks for the help.
Dirk


Joachim Duerr (ADS) Posted on 2009-01-23 10:20:06.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: replicate multiple servers to one
Newsgroups: Advantage.Replication
References: <4978926e@solutions.advantagedatabase.com> <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com> <4979744b@solutions.advantagedatabase.com>
Date: Fri, 23 Jan 2009 11:20:06 +0100
User-Agent: XanaNews/1.19.1.110
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <497999c0@solutions.advantagedatabase.com>
X-Trace: 23 Jan 2009 03:19:44 -0700, 130.214.79.11
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Replication:345
Article PK: 1134200


Dirk Verleyen wrote:

>Could you tell me what a replication licence would cost?

Dirk,
please contact your ads rep in our office regarding prices.

--
Joachim Duerr
Advantage Presales
Sybase GmbH
please don't reply via email


Dirk Verleyen Posted on 2009-01-29 15:47:02.0Z
Date: Thu, 29 Jan 2009 16:47:02 +0100
From: Dirk Verleyen <dirk.verleyennospam@carfac.be>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: Re: replicate multiple servers to one
References: <4978926e@solutions.advantagedatabase.com> <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com> <4979744b@solutions.advantagedatabase.com> <497999c0@solutions.advantagedatabase.com>
In-Reply-To: <497999c0@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.83.111.86
Message-ID: <4981cf85@solutions.advantagedatabase.com>
X-Trace: 29 Jan 2009 08:47:17 -0700, 81.83.111.86
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.83.111.86
Xref: solutions.advantagedatabase.com Advantage.Replication:350
Article PK: 1134205

Joachim Duerr (ADS) schreef:

> Dirk Verleyen wrote:
>
>> Could you tell me what a replication licence would cost?
>
> Dirk,
> please contact your ads rep in our office regarding prices.
>

Hi,

The replication is working fine, but could you help me with the following:

- only the "new" records are send to the server, how can I initally send
all the records in the table?
- Is there any way to create the whole table structure? That way I can
start with a clean data dictionary.
- What if we add fields to a table in the source dictionary? Will that
field also be created in the destination?

Thanks
Dirk


Joachim Duerr (ADS) Posted on 2009-01-30 08:17:50.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: replicate multiple servers to one
Newsgroups: Advantage.Replication
References: <4978926e@solutions.advantagedatabase.com> <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com> <4979744b@solutions.advantagedatabase.com> <497999c0@solutions.advantagedatabase.com> <4981cf85@solutions.advantagedatabase.com>
Date: Fri, 30 Jan 2009 09:17:50 +0100
User-Agent: XanaNews/1.19.1.110
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <4982b786@solutions.advantagedatabase.com>
X-Trace: 30 Jan 2009 01:17:10 -0700, 130.214.79.11
Lines: 26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Replication:351
Article PK: 1134206


Dirk Verleyen wrote:

>- only the "new" records are send to the server, how can I initally
>send all the records in the table?

if you check 'merge update' and 'merge insert' then just do an update
on all records in the able to put them into the replication queue:

Update mytable set id=id

>- Is there any way to create the
>whole table structure? That way I can start with a clean data
>dictionary.

no

>- What if we add fields to a table in the source
>dictionary? Will that field also be created in the destination?

not automatically.

--
Joachim Duerr
Advantage Presales
Sybase GmbH
please don't reply via email


Josh Neider Posted on 2009-01-30 15:37:20.0Z
From: "Josh Neider" <jneider@sybase.com>
Newsgroups: Advantage.Replication
References: <4978926e@solutions.advantagedatabase.com> <864d0bcb16ac18cb4a88fb3c4192@devzone.advantagedatabase.com> <4979744b@solutions.advantagedatabase.com> <497999c0@solutions.advantagedatabase.com> <4981cf85@solutions.advantagedatabase.com>
In-Reply-To: <4981cf85@solutions.advantagedatabase.com>
Subject: Re: replicate multiple servers to one
Date: Fri, 30 Jan 2009 08:37:20 -0700
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8050.1202
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8050.1202
NNTP-Posting-Host: 10.24.34.232
Message-ID: <49831e9c@solutions.advantagedatabase.com>
X-Trace: 30 Jan 2009 08:37:00 -0700, 10.24.34.232
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.232
Xref: solutions.advantagedatabase.com Advantage.Replication:352
Article PK: 1134207

Hello Dirk,

You can also check out this knowledge base item "How To Begin Replication to
a Blank Database"
http://devzone.advantagedatabase.com/dz/content.aspx?Key=17&RefNo=080912-2077

For deployment of a replication database you may consider just deploying the
Data Dictionary and have all of the tables properties Auto Create option set
to "yes". This way when you run the touch function it will also create the
tables for you based off of the structure stored in the data dictionary.
Unfortunately at this time structural changes are not replicated so if you
make a change to the publication database you will need to manually make
that change to the destination database.

I hope this additional info helps.

Josh

"Dirk Verleyen" <dirk.verleyennospam@carfac.be> wrote in message
news:4981cf85@solutions.advantagedatabase.com...
> Joachim Duerr (ADS) schreef:
>> Dirk Verleyen wrote:
>>
>>> Could you tell me what a replication licence would cost?
>>
>> Dirk,
>> please contact your ads rep in our office regarding prices.
>>
> Hi,
>
> The replication is working fine, but could you help me with the following:
>
> - only the "new" records are send to the server, how can I initally send
> all the records in the table?
> - Is there any way to create the whole table structure? That way I can
> start with a clean data dictionary.
> - What if we add fields to a table in the source dictionary? Will that
> field also be created in the destination?
>
> Thanks
> Dirk