MSSQL to Postgres - pgloader failed to find anything in schema "public" in target catalog.

[it4factory]

Hi, Im getting the following error

pgloader-mssql-to-postgres | 2026-01-01T19:50:38.006000Z LOG pgloader version "3.6.7~devel"
pgloader-mssql-to-postgres | 2026-01-01T19:50:38.064001Z LOG Migrating from #<MSSQL-CONNECTION mssql://sa@mssql:1433/test1 {1007E428F3}>
pgloader-mssql-to-postgres | 2026-01-01T19:50:38.064001Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgre-admin@postgres-apps:5432/test2 {1007E43863}>
pgloader-mssql-to-postgres | Max connections reached, increase value of TDS_MAX_CONN
pgloader-mssql-to-postgres | KABOOM!
pgloader-mssql-to-postgres | SIMPLE-ERROR: pgloader failed to find anything in schema "public" in target catalog.
pgloader-mssql-to-postgres | An unhandled error condition has been signalled:
pgloader-mssql-to-postgres | pgloader failed to find anything in schema "public" in target catalog.

pgloader.load file

LOAD DATABASE
FROM mssql://sa:xxx@mssql:1433/test1
INTO postgresql://postgre-admin:xxxx@postgres-apps:5432/test2

alter schema 'dbo' rename to 'public'

WITH
data only,
create no schemas,
workers = 1,
concurrency = 1
CAST
type datetime to timestamp,
type bit to boolean
;

docker.compose file

services:
pgloader:
image: dimitri/pgloader:latest
container_name: pgloader-mssql-to-postgres
volumes:
- ./pgloader.load:/pgloader.load:ro
command: ["pgloader", "/pgloader.load"]
restart: "no"
environment:
TDS_MAX_CONN: 50
networks:
- web

networks:
web:
external: true