Re: replication oracle / sql server

Praxis International (web site: http://www.praxisint.com ) has a couple of products which might help, both move data between Oracle and Microsoft SQL Server (among others) in either direction.

OmniReplicator is a data change replicator which captures updates on a source (Oracle, MS SQL Server, Sybase, Informix or DB2) and copies them to a target (which can be on any of the source DBMSs or Ingres, Rdb, or DB2/6000 as well). OmniReplicator permits update-anywhere replication with data collision detection and resolution should two or more people try to update the same data at the same time in different locations.

OmniCopy is a snapshot copy product. It copies extracts of data from a source to a target. OmniCopy supports the same source and target DBMSs as OmniReplicator. OmniCopy offers a few options for how the data is applied at the target. Full refresh mode completely replaces the target table with the incoming data. Append mode adds the incoming data to the target. You can also elect to update rows where the keys on existing data are the same as the incoming data (that way you can merge data from two different source tables into one target table.

Both OmniReplicator and OmniCopy allow you to select just particular rows and columns for replication or copy. That way, you don't have to keep the full table at the target if you don't need it -- which also reduces the amount of data transmitted.

Praxis' web site, http://www.praxisint.com , has more information, including contact information.

nishb_at_4cs.com wrote:
>
> I am looking to replicate data between SQL Server
> and Oracle 7.3
>
> I am looking for updateable snapshots. I do have
> the gateway, but as per the
> gateway books I can just UPDATE data in from sql
> server to oracle server and COPY data from oracle
> to sql server, but I can't do replication, would
> appreciate if there is some preexistent code or
> something that i could use to do replication
> between the two or if u could suggest a tool or
> something.
>
> Thanks.
>
> Nish
 

-- 
Joel Klebanoff
Klebanoff Associates, Inc.
Toronto, Canada
Phone: (416) 924-6510
  Fax: (416) 924-8185