Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL MERGE to remote (linked) server table

Tags:

sql

sql-server-2008

sql-merge

Is it possible to utilize the SQL MERGE function on a linked server's database table? The end goal is to synchronize the remote table with our local SQL server table. I’ve done some research online and couldn’t find any related information. If it is possible how would you setup the source and target statements?

like image 391
devHead Avatar asked Mar 06 '13 00:03

devHead

People also ask

Can we use MERGE with CTE in SQL?

The MERGE statement syntax specifies USING( table-reference ). Andtable-reference can be a VIEW, and a VIEW can be built over a CTE.

How do I MERGE data from one table to another in SQL Server?

Multiple tables can be merged by columns in SQL using joins. Joins merge two tables based on the specified columns (generally, the primary key of one table and a foreign key of the other). Below is the generic syntax of SQL joins. USING (id);

How can use linked server in SQL Server query?

Right-click on the Linked Server node and choose New Linked Server. In the General tab of the New Linked Server window, choose a name for your linked server, then choose the type of the server you need to connect to using that linked server.

1 Answers

To reiterate the comment by @Mikael Eriksson, yes, you can. The target of a MERGE cannot be remote, but the source of a MERGE can be remote. So, if you can run the MERGE statement from your server in FL, then it is quite possible. For example, you could run something like this on your remove server in FL:

MERGE INTO "local FL table" USING "CT server"."database"."schema"."same table" ON ...
like image 158
Michael Painter Avatar answered Sep 17 '22 15:09

Michael Painter
Sign in to Comment

Related questions

Many tables or rows, which one is more efficient in SQL?
How to call mysql function using querydsl?
Is LIMIT clause in HIVE really random?
How to use variables in SQL raiserror
Shared hit cache in postgreSQL
ON CONFLICT DO UPDATE has missing FROM-clause
Activity log of database MS SQL Server
Find all columns of type nvarchar(max) in all tables in a SQL Server database
numeric(38,0) as primary key column; good, bad, who cares?
How do you do many to many table outer joins?
How to get Windows Log-in User Name for a SQL Log in User
PreparedStatement.setString() method without quotes [duplicate]
Get column names
In what situations should I use Entity SQL?
How to select the top n from a union of two queries where the resulting order needs to be ranked by individual query?
How to share a table between multiple Postgresql databases
MySQL not using index for ORDER BY
Matching of strings in SPARQL?
Using different order by with union
Ignore certain columns when using BULK INSERT

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!