Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Friday, July 25, 2014 5:18 AM
Points: 31, Visits: 220
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: Friday, July 25, 2014 5:18 AM
Points: 31, Visits: 220
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: Monday, July 21, 2014 12:34 PM
Points: 1,157, Visits: 3,255
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

Post #835061
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse