Can I use MERGE statement with Linked Server tables

  • I have database on sql 2008 and database with same structure on sql 2000

    The data in 2008 version are more actual and I need to synchronize them with 2000.

    Is it possable to do it with MERGE statement?

    I plan remove all FK and disable all triggers previously and tie 2000 as linked to 2008

    and use MERGE after that

  • The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.

  • suvorav (12/16/2009)


    The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.

    Correct. If your looking to use a remote table as a source -

    http://www.sqlservercentral.com/scripts/SQL+Server+2008/66507/[/url]

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

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