dbSlice sample: copy only the missing rows from SQL Server to PostgreSQL from the command line
Article: https://dbslice.net/blog/copy-missing-rows-sqlserver-postgresql

01-sqlserver-source.sql     Sample source table (20,000 generic tickets, no real data). Run with sqlcmd.
02-postgres-target.sql      The PostgreSQL copy with a gap (19,159 rows). Run with psql.
support-tickets-check.json  Job: compare data (read only).
support-tickets-load.json   Job: insert only the keys missing in the target.
run-linux.sh                Linux (Docker edition): runs the jobs through the jobs API (curl + jq, token read from a file).
run-windows.ps1             Windows: runs the jobs with dbSlice.exe.

The job files name connection profiles (MASTER, Server-dbPostg); rename them to your own profiles.
No job file holds a password or a token.

Linux, without the API (Docker edition with the --run option): run a job directly on the Docker host with --run.
It needs no token, waits for the run, prints the log and ends with an exit code (handy for cron):
  docker run --rm -v <data volume>:/data -v <logs volume>:/logs dbslice-web --run support-tickets-check
  docker run --rm -v <data volume>:/data -v <logs volume>:/logs dbslice-web --run support-tickets-load
Add --network <name> only when the databases are reached by container name. If the container is already up:
  docker exec dbslice-web dotnet DBSlice.UiWeb.dll --run support-tickets-check
