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
