SQL Server Performance Forum – Threads Archive

SQL Server 2000 Replication

Hello SQL GURU’s, I need some help with my SQL server replication. I have never replicated data to Oracle and this is the first time that I am doing so. I cannot seem to figure out how to replicate data to Oracle by changing the Article name differently onto the destination. For e.g. I want to replicate data from COMPANY to MYCOMPANY without changing the schema, only the table names are different. I cant seem to get the table mappings to work. I have tried using the SQL Server transformation services but the DTS isnt working for me.. I would greatly appreciate anyone’s help.. Thank You VS

Refer to the books online about replication using heterogenous data sources and I think Oracle Transparent Gateway allows you to create a database link from Oracle to SQL Server. If you are going to be rolling your own replication system and you don’t need a particularly sophisticated solution, Oracle Transparent Gateway would be a good solution. If you need differential rebuilds (i.e. only replicate changes), a more loosely coupled solution, etc. you would want to go with Oracle Streams. You’d have to find some queueing software that would interface with Oracle Advanced Queues (on which Oracle Streams is based) and would also interface with SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, thank you for your response. Is there no way to just use replication with DTS to do the transformation and to apply data to a table with a different name? I have the publication created with the DTS job, however it will not run and keeps on failing on just running updates to the tables. Or do I have to go with a third party software to get this up and running? Thanx VS

Yes, you can use DTS to get the data out of Oracle.
What was the error while updating the tables? SQL Server has capability to performing replication to oracle, then why to go for third party solutions. http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci854771,00.html andhttp://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:442019934371 for information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>