Sybase - Ingres - Sybase replication - is it possible ?

[Graham Parsons]

Our current relational systems are built around Ingres yet we're
considering using SYbase for new developments. There would be a
requirement to maintain data consistency between all databases.

In the Ingres environment we could employ Ingres's Replicator product,
yet this can't support full replication with Sybase. Neither can the
Sybase replicator support this type of replication.

Has anyone implemented anything that can replicate to and from an
Ingres database ?

TIA

Graham Parsons
Forest COnsulting Limited

[Natarajan V Nellicherry]

hi there,
it depends on the ingres & sybase version. the best solution will be
to go in for the sybase gateway product OMNIConnect. but the current
version of OMNIConnect is single threaded for ingres connections. so
concurrent users will have problems. multi-threaded connections are
not supported now. as per sybase they will be coming out with a full
support by the 3rd quarter of '97 (keep ur fingers crossed !!!)

we have been soft pedalling this work for the past 12-15 months as we
were unable to get any viable suggestion. i wld be interested in the
suggestions coming up on the web.
thanx
_____________________________________________________
Natarajan V Nellicherry
Mayo Foundation
(507) 281- 4548 (H)
(507) 266 - 5022 (W)
(507) 284 - 1927 (Fax)
nellicherr...@mayo.edu (E-mail)
_____________________________________________________
Inspite of my best efforts the contents herein may be
incorrect, and should be used at readers own risk.
_____________________________________________________

Graham Parsons <gra...@fcltd.demon.co.uk> wrote in article
<32dd59fa...@127.0.0.1>...

[Jim Campbell]

> Graham Parsons <gra...@fcltd.demon.co.uk> wrote in article
> <32dd59fa...@127.0.0.1>...
> > Our current relational systems are built around Ingres yet we're
> > considering using SYbase for new developments. There would be a
> > requirement to maintain data consistency between all databases.
> >
> > In the Ingres environment we could employ Ingres's Replicator
product,
> > yet this can't support full replication with Sybase. Neither can
the
> > Sybase replicator support this type of replication.
> >
> > Has anyone implemented anything that can replicate to and from an
> > Ingres database ?
> >
> > TIA
> >
> > Graham Parsons
> > Forest COnsulting Limited
> >

If you are willing to write some code, there is no reason why Sybase
replication server can't help you. If there is not a replication
agent for Ingres that meets your needs, you can always write your own.
Once you have done this, you can enjoy the benefits that Sybase
replication server provides. I think there already is an Ingress
replication agent. I would have to check to make sure. In the worst
case,
there is an ODBC replication agent. I have no first hand experience
with
it, however, it may be worth a look.

Jim Campbell