pgloader
pgloader copied to clipboard
Unable to connect to Azure SQLServer with Pgloader
migrate.load file data:
LOAD DATABASE
FROM mssql://user:[email protected]/Configuration
INTO postgresql://user:[email protected]/Configuration?sslmode=require
WITH include no drop, create tables, create indexes, reset sequences,
data only
SET work_mem to '16MB',
maintenance_work_mem to '512 MB';
I'm getting the following error but not able to see any clear log: pgloader --verbose migrate.load 2024-09-13T04:19:46.000000Z NOTICE Starting pgloader, log system is ready. 2024-09-13T04:19:46.010000Z LOG pgloader version "3.6.3~devel" 2024-09-13T04:19:46.010000Z LOG Data errors in '/tmp/pgloader/' 2024-09-13T04:19:46.010000Z LOG Parsing commands from file #P"/home/srinim/migrate.load" 2024-09-13T04:19:49.130000Z LOG Migrating from #<MSSQL-CONNECTION mssql://[email protected]:1433/Configuration {100800E423}> 2024-09-13T04:19:49.130000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://[email protected]:5432/Configuration {100800FF03}> 2024-09-13T04:19:49.990000Z ERROR mssql: Failed to connect to mssql at "test-sqlserver.database.windows.net" (port 1433) as user "user": Connection to the database failed for an unknown reason.
Note: I'm able to connect to ms sql server from other utilities only having issue with pgloader