Post reply

Can I use MERGE statement with Linked Server tables

  • December 16, 2009 at 3:28 am

    #213606

    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

  • December 16, 2009 at 4:53 am

    #1092914

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

  • December 16, 2009 at 7:23 am

    #1092980

    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]

    Tommy

    Follow @sqlscribe

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

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