Linked Servers vs Integration Services RRS feed

  • Pergunta

  • Hi,

    When I want to move data between two databases, what better choice.

    A) Linked Servers 

    database local-> Linked Servers -> database azure

    b) ETL

     database local create procedure xml -> integration service -> serialize xml to object c#> call wcf service async(queue-servicebus) ->  persist database  azure

    segunda-feira, 31 de agosto de 2015 18:46