Re: Replication

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 13 May 2001 23:19:15 -0700
Message-ID: <3AFF78E3.D0C027C7_at_exesolutions.com>


Khurram Izhar wrote:

> Hi All,
>
> I am working on an oracle replication project. The replication has to take
> place between Oracle 7.3.4 to any other databaes. I just wanted to confirm
> is there a possibility of replicating from Oracle 7.3.4 to SQL 7.0??
>
> Also if SQL is not possible can we replicate from Oracle 7.3.4 to Oracle
> 8.1.5.0.0?
>
> I have been working on SQL for the past couple of years, oracle is new to
> me.
>
> Waiting for the expert advice.
>
> Thanks
> Khurram

If by "any other database" and your reference to "SQL 7.0" you mean what I think you mean. No: You can not.

Replicating from Oracle 7.3.4 to 8.1.5 is not only possible it is simple.

[Quoted] PS: The product name is SQL Server. In spite of the fact that Microsoft likes [Quoted] [Quoted] to pretend it invented computing it didn't. SQL is an ANSI standard language. [Quoted] [Quoted] SQL Server is a product. If you want to communicate with people and have them [Quoted] [Quoted] understand you please have the courtesy to make the distinction.

[Quoted] And do yourself another favor. Do not try to use what you know of SQL Server [Quoted] [Quoted] to work in Oracle. You will end up hating Oracle, doing lousy work, and we will not exactly overflow with affection toward you. Read the Oracle manuals [Quoted] [Quoted] and books and write PL/SQL not TSQL. They are very different as are the products.

Daniel A. Morgan Received on Mon May 14 2001 - 08:19:15 CEST

Original text of this message