• Ok so finally getting the testing done on this.

    So far I am finding OPENQUERY to be a slower method. Are there particular things I should be utilizing in order to accomplish this? I am simply starting off with the basic insert script of

    select column1, column2 from openquery(sourceserv, 'select column1, column2 from table') as t1

    LEFT JOIN destinationtable as t2

    on t1.key = t2.key

    where t2.key is null.

    It is taking quite a long time to accomplish but perhaps I am not using the best method here?

    Link to my blog http://notyelf.com/