Answer the question
In order to leave comments, you need to log in
Is it possible to link MSSQ and MySQL tables via LinkedServer by guid?
There are two SQL servers: one MSSQL, the second MySQL. The second is connected to the first as a LinkedServer.
There is a need to export data from MSSQL to MySQL with control over the presence of exported data on a remote server.
All requests through openquery.
In the usual case, we check that there is no data in the remote table through left join and is null
insert into OPENQUERY (MYSQL, 'select
Id, ...
FROM mysqltable')
select
ms.Id, ...
from OPENQUERY (MYSQL, 'select * FROM mysqltable') my
right join MSSQLTable ms on my.Id = ms.Id
where My.Id is null
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question