Results 1 to 4 of 4

Thread: MSSQL TSQL triggers updating Oracle database

  1. 06-02-2003, 03:35 PM #1
    TTTT
    TTTT is offline Registered User
    Join Date
    Jun 2003
    Location
    Florida
    Posts
    2

    Talking MSSQL TSQL triggers updating Oracle database

    How do I put a trigger on a MSSQL database that will update an Oracle database. I suppose you would need an ODBC connection, then what?
    Reply With Quote Reply With Quote
  2. 06-02-2003, 04:10 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can try using a linked server in sql server.

    Check sp_addinkedserver in BOL
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 06-02-2003, 04:40 PM #3
    TTTT
    TTTT is offline Registered User
    Join Date
    Jun 2003
    Location
    Florida
    Posts
    2
    Can you be more specific?
    Reply With Quote Reply With Quote
  4. 06-02-2003, 09:43 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    For creating linked server here is article.

    http://www.databasejournal.com/featu...le.php/1756161
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules