Post reply

SQL Server and Oracle replication

  • January 10, 2007 at 12:52 am

    #176426

    Hello,

    I have this scenario where a remote SQL server will be populated by web updates and handheld devices.   On a central location will be an Oracle database.  There will also be updates on the Oracle database.

    I need to reflect all changes on the SQL server to the Oracle database and vice versa so I need some sort of replication between the two databases.  The SQL server location at times will not have connectivity to the Internet so such case all updates in either direction must be put on a queue.

    What is the best technical solution to the problem I mentioned above?

    Thank you.

  • January 15, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • January 19, 2007 at 3:50 am

    #684227

    Hi,

    in one of my projects we have used triggers to capture those changes applications made to database tables and then processed them into the tables of another database.

    This implies that you will need to set up some transfer and processing tasks on either side.

    You may want to limit yourself to only SQL Server and update the Oracle instance from SSIS packages as well.

    A lot depends on your specific setuo though.

    Michael

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

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