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.

Replicating from sql2005 into ADS

2 posts in Replication Last posting was on 2007-03-30 11:09:00.0Z
jherman Posted on 2007-03-02 22:38:23.0Z
From: "jherman" <jherman@jherman.net>
Newsgroups: Advantage.Replication
Subject: Replicating from sql2005 into ADS
Date: Fri, 2 Mar 2007 14:38:23 -0800
Lines: 7
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: 67.151.99.130
Message-ID: <45e8a652@solutions.advantagedatabase.com>
X-Trace: 2 Mar 2007 15:33:54 -0700, 67.151.99.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.151.99.130
Xref: solutions.advantagedatabase.com Advantage.Replication:185
Article PK: 1134044

We have a production ADS database that we would like updated when a sql2005
database is updated. Is is possible to publish from sql2005 to ADS- maybe
using ODBC? Could ADS "subscribe" to the data? I know I could write a
program using triggers, etc to accomplish this but I would rather take the
easy way out. Any ideas?


Paul Man Posted on 2007-03-30 11:09:00.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.Replication
References: <45e8a652@solutions.advantagedatabase.com>
Subject: Re: Replicating from sql2005 into ADS
Date: Fri, 30 Mar 2007 12:09:00 +0100
Lines: 14
Organization: DSoft
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: 82.141.233.142
Message-ID: <460ceef9@solutions.advantagedatabase.com>
X-Trace: 30 Mar 2007 05:05:29 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:191
Article PK: 1134049

For the opposite I use a rowversion column to distinguish changes and read
those records that have a greater rowversion than the previous one read.
Deleted records have to be handled seperately.

"jherman" <jherman@jherman.net> wrote in message
news:45e8a652@solutions.advantagedatabase.com...
> We have a production ADS database that we would like updated when a
> sql2005 database is updated. Is is possible to publish from sql2005 to
> ADS- maybe using ODBC? Could ADS "subscribe" to the data? I know I could
> write a program using triggers, etc to accomplish this but I would rather
> take the easy way out. Any ideas?
>