Updating an oracle table from a sql query

  • What would be the best ways of updating an oracle table from a query in SQL server? Would I need to create a SQL table from the query then update the oracle table?

    I know one option would be to use Linked Servers but I have heard there are security concerns with this method. Would creating an SSIS package be the most suitable method?

Viewing 0 posts

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