Bulk appended import data. If the primary key exists, update the data. How to import data efficiently?
The following operations can be performed in postgresql. Does sqlserver have similar features?
CREATE TABLE if not exists ${tempTableName} (LIKE ${tableName} INCLUDING defaults)
COPY $table FROM STDIN WITH (NULL '\\N', FORMAT CSV, DELIMITER E'${fieldDelimiter}'
insert into tableName (column1.....) select * from tempTableName on conflict (id) DO UPDATE SET (......)
Bulk appended import data. If the primary key exists, update the data. How to import data efficiently? The following operations can be performed in postgresql. Does sqlserver have similar features?
https://github.com/melin/datatunnel/blob/master/connectors/jdbc/src/main/scala/com/superior/datatunnel/plugin/jdbc/support/CopyHelper.scala