Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can I use MERGE statement with Linked Server tables Expand / Collapse
Author
Message
Posted Wednesday, December 16, 2009 3:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:45 AM
Points: 49, Visits: 541
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
Post #834948
Posted Wednesday, December 16, 2009 4:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:45 AM
Points: 49, Visits: 541
The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.
Post #834981
Posted Wednesday, December 16, 2009 7:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 18, 2016 5:39 AM
Points: 1,160, Visits: 3,359
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/


Tommy

Follow @sqlscribe
Post #835061
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse