Re: Oracle and Sql

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 25 Oct 1999 16:03:38 -0700
Message-ID: <3814E1CA.EC6B2AFE@us.oracle.com>

Manish

This can be done automatically via the transparent gateway and Oracle replication services, but I'd have to ask why you want to do this. As with all products, there are differences between Oracle and SQL Server in how particular things are done, so something that works in one may not work in the other. I would think you'd be far better off to have both the development and production environments run on one product.

HTH. Pete

msrivast_at_my-deja.com wrote:

> We are using Oracle as our production enviroment and Sql Server for our
> development enviroment. We want to easily synch the enviroments every
> few days. Is there a way in Oracle to pucsh data or pull data into sql
> server in an automated way. We have ami8xed NT and Unix/Linux enviro. I
> am thinking of writing something in java that will use JDBC to do this.
> Any suggestions?
>
> manish
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Mon Oct 25 1999 - 18:03:38 CDT