Re: Replication

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.

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

And do yourself another favor. Do not try to use what you know of SQL Server 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 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 - 01:19:15 CDT