SQL Server Performance

SQL Server 2000 Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by vshaikh, Apr 20, 2004.

  1. vshaikh New Member

    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
  2. satya Moderator

    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.
  3. vshaikh New Member

    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
  4. satya Moderator

    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.

Share This Page