I am trying to load data from a table in Oracle server to SQL server and data that gets loaded has mismathc rows. I am using Openquery to load the data. The data gets loaded perfectly fine in SQL Server 2013 but rows mismatch in SQL Server 2019. Anyone has ever come across this?
Source Server data
| State | City |
|---|---|
| NY | Syracuse |
| Florida | Orlando |
| Texas | Austin |
Data loaded in destination server
| State | City |
|---|---|
| NY | Austin |
| Florida | Syracuse |
| Texas | Orlando |
Below is the Openquery i am using
INSERT INTO table321
SELECT \* FROM OPENQUERY(hjgg, ''
select \*
FROM table1'')