January 22, 2005 at 5:49 am
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!
January 25, 2005 at 9:45 am
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.
January 25, 2005 at 3:10 pm
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.
January 27, 2005 at 9:48 am
Actually, you can replicate both ways using each vendors replication tools.
Publish from SQL Server to an Oracle subscriber by:
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.
January 31, 2005 at 4:35 pm
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
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply