Post reply

From Oracle to SQL Server real time

  • November 15, 2013 at 2:21 pm

    #148320

    Hi

    When certain data change in a Oracle table, I wish to move the changed data to a SQL Server immediately.

    Can Oracle trigger a call to a SSIS package, or to the SQL Server Agent.

    Is there other ways to call a SSIS package from Oracle when a change appears?

  • November 17, 2013 at 4:12 am

    #1666925

    You might want to ask this in an Oracle forum.

    The question is related to the source (Oracle) and not to the target (SSIS or SQL Server).

    Anyhow, the solution won't be "real time" just "near time".

    If the source would have been SQL Server I probalby would use Query Notification. Not sure, if such a technology is available in Oracle.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 17, 2013 at 5:33 am

    #1666932

    Why SSIS, try a replication? Check this:

    http://blogs.msdn.com/b/sqlserverfaq/archive/2008/10/16/step-by-step-procedure-to-implement-sql-server-transactional-replication-with-oracle-as-publisher.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply