Replication to or from Sybase and Oracle

• Jaco Louw

  Valued Member

  Points: 67

  More actions

  January 22, 2005 at 5:49 am

  #87796

  What are the basic steps for setting up my SQL Replication server to replicate to a Sybase/Oracle replicator or to allow replications from a Sybase/Oracle replicator.

  Thanks guys!

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  January 25, 2005 at 9:45 am

  #538987

  I don't think you can really do it as replication. I believe you would have to do it as a DTS (Data Transformation) task.

  You will need to have the ODBC drivers for Oracle and/or Sybase on the SQL server and then create the ODBC links to the database.

  You may be also able to set-up ADO connections in the DTS.

  You will also need some sort of timestamp/index on all tables that you are importing from unless you just want to dump all data and re-import it every time.

  This is just my $0.02. There are others around here with more experience.

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.

• t.o.

  SSC Veteran

  Points: 220

  More actions

  January 25, 2005 at 3:10 pm

  #539058

  I've used 3rd party tools such as Data Mirror to accomplish log-based, bi-directional replication between Oracle and SQL Server targets.  Don't know of any built-in functionality in either Oracle or SQL Server to accomplish heterogeneous replication.  But tools like Data Mirror work well, in real time too if that is a requirement.

• t.o.

  SSC Veteran

  Points: 220

  More actions

  January 27, 2005 at 9:48 am

  #539378

  Actually, you can replicate both ways using each vendors replication tools. 

  Publish from SQL Server to an Oracle subscriber by:

  1. install Oracle client on the SQL Server and distributor server (along with TNSNAMES configuration for Oracle connectivity)
  2. set up Oracle as a linked server via OLE DB or ODBC
  3. Identify the Oracle linked server as a heterogeneous subscriber in the Replication wizard

  Publish from Oracle to SQL:

  Generally, just use Oracle replicationor stream, but identify the SQL Subscriber through Oracle Transparent Gateway for SQL Server ($$$) or possibly through the free Oracle Generic Connectivity feature. 

• David Liu-205385

  SSC Journeyman

  Points: 77

  More actions

  January 31, 2005 at 4:35 pm

  #539835

  Read the instruction in this sample chapter:

  http://www.nwsu.com/lowres_replication_ch02.pdf

  I was able to create a Transaction replication with Sybase ASE ODBC Subscriber.

  I was also able to create a partially working (but mostly not working) Sybase ASE OLEDB Subscriber.

  Good Luck,

  David