Re: sqlserver 2000 to oracle replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DWinter (dwinter_at_attbi.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 03:20:15 -0500

You can create a Linked Server to the Oracle database and every week dump to
the linked server.
This requires the Oracle client and Oracle ODBC driver be installed on the
database server, but will work.

"Hubert Mayr" <huma1@gmx.net> wrote in message
news:1080286248.422731@news.liwest.at...
> Hi!
>
> I want to make a replication from sqlserver 2000 to oracle 9.
> I want that my sqlserver database is one time the week replicated to an
> oracle database.
> That oracle database should be read only for my users.
> Is that possible? How?
>
> Thanks!
>
>

Relevant Pages

  • Re: Link to Oracle 9.2.0
    ... If you are requiring to use the oracle database as a linked server then ... check out sp_addlinkedserver in books online: ...
    (microsoft.public.sqlserver.connect)
  • Oracle/DBI
    ... I am trying to connect to an Oracle Database. ... I was using perl DBI and DBD:;Orcacle for this purpose. ... using my perl script. ... When I had not installed the Oracle client, I was able to connect using ...
    (perl.dbi.users)
  • alternative to DBD::Oracle that does not use OCI?
    ... is there some other sort of DBD module that can ... connect to an Oracle database without needing to install Oracle's pile ... of steaming code? ... Oracle client? ...
    (perl.dbi.users)
  • System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
    ... I'm getting the following error when connecting to Oracle database through ... Oracle client software version 8.1.7 or greater. ...
    (microsoft.public.dotnet.framework.adonet)
  • Oracle Database and VB6
    ... Any sample code in connecting to Oracle Database in the VB 6? ... Where can i download the Oracle ODBC driver so my program can connect to the Oracle Database in my VB 6 application? ...
    (microsoft.public.vb.general.discussion)