Update sql server tables from Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Update sql server tables from Oracle

  1. #1
    Join Date
    Apr 2004
    Posts
    20

    Update sql server tables from Oracle

    Hi,


    I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

    how can i do such a thing?

    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Read abt Transparent Gateways.. may be it helps..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Oct 2002
    Posts
    109

    Re: Update sql server tables from Oracle

    Hi You can also use ADO connection in VB to transfer data from sql server to the Oracle.
    Or
    u can use the DTS of sqlserver

    regards

    praveen

    Originally posted by Shadis
    Hi,


    I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

    how can i do such a thing?

    Thanks

  4. #4
    Join Date
    Feb 2001
    Posts
    295

    Re: Re: Update sql server tables from Oracle

    Originally posted by prav_saras
    Hi You can also use ADO connection in VB to transfer data from sql server to the Oracle.
    Or
    u can use the DTS of sqlserver

    regards

    praveen

    Hmmm... you would need to fire the DTS job from SQL Server side, not Oracle. I can only imagine it being done on an synchronous basis, not asynchronous like a trigger on Oracle would do. Can you explain that?

    Since Transparent Gateways option is licensed separately I'd consider generic connectivity of HS before, maybe it meets the requirements:

    http://download-west.oracle.com/docs...gvsgc.htm#9912
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015

    Re: Update sql server tables from Oracle

    Originally posted by Shadis
    Hi,


    I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

    how can i do such a thing?

    Thanks
    You could write a java package, place it in the Oracle database, and have that java package take some data and insert it into a sql server database using the jdbc driver for SQL Server. Then all you would have to do is call the Java package from your trigger and pass the right information.

    You could probably do the same thing with an external c program.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width