pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

Unable to connect to Azure SQLServer with Pgloader

Open srinivasmummareddy opened this issue 5 months ago • 1 comments

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

srinivasmummareddy avatar Sep 13 '24 04:09 srinivasmummareddy