Data Communication Between SQL Server Networks

The IP address of a is 192.168.0.1.
The IP address of B is 192.168.0.2.
One database in a is Testa, table tablea User: SA, password: SA, 123456

One database in B is testb, table tableb User: SA, password: SA, 123

Now we want to export data from tableb to tablea.
Insert into Testa. DBO. DB
Select * From OpenRowSet ('sqloledb', '192. 168.0.2 '; 'sa'; '123', testb. DBO. testb)

If you only import data with different IDs:

Insert into Testa. DBO. dB (userid, username, userphoto)

Select userid, username, userphoto from OpenRowSet ('sqlodb', '192. 168.0.2 '; 'sa'; '123', testb. DBO. testb)
Where userid not in (
Select userid from Testa. DBO. Testa
)
The import operation must be performed on client B !!!

Pay attention to Punctuation !!!