Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Replication from SQL Server to Oracle 8.1.7

Re: Replication from SQL Server to Oracle 8.1.7

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 4 Jul 2002 09:38:36 +0100
Message-ID: <3d24098d$0$232$ed9e5944@reading.news.pipex.net>


I'd install the Oracle oledb providers and then set up a DTS package and schedule it using sql server job scheduling system.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Andrew Plato" <gilliankitty_at_yahoo.com> wrote in message
news:ca617cfa.0207031647.1d85fb04_at_posting.google.com...

> My Oracle skills are a bit clunky, so if this is a really stupid
> question, I apologize. You can laugh at me. I won't mind. :-)
>
> I need to do a very simple one way replication from that database to
> an Oracle 8.1.7 system. All updates will be done on the SQL Server
> system, so there is no need for a transparent gateway. The updates
> don't need even to be done immediately. I could live with a periodic
> refresh of the data like once an hour or once every 15 minutes.
>
> I've set up a replication publisher in SQL Server, I can connect to
> the Oracle database using SQL*Plus, I installed the Oracle ODBC
> drivers on the SQL Server box...but then I get lost. What next? Could
> somebody point me in the right direction or at least point me to a
> document where I can learn how to do this?
>
> Thanks for the help.
>
> Andrew Plato
Received on Thu Jul 04 2002 - 03:38:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US