Post reply

Is Transactional replication can be configured for data transfer from SQL server 2005 to oracle

  • August 10, 2009 at 4:49 am

    #140590

    I need to transfer a query output (using multiple tables of the database) from SQL server 2005 to oracle and this needs to be updated over the period of time.

    Do Transactional replication option suits this scenario?

    Can anyone help in this.

    Thanks

  • August 10, 2009 at 6:18 am

    #1036712

    Your scenario is not exactly clear.

    But yes Replication can be setup into hetrogenious environment.

    Reference Link: http://msdn.microsoft.com/en-us/library/ms151835(SQL.90).aspx

    Also if you would like to send output of a query to ORCALE; you can use SSIS.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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