You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
LOAD DATABASE
FROM mssql://user:pass@test-sqlserver.database.windows.net/Configuration
INTO postgresql://user:pass@test-postges-poc.postgres.database.azure.com/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://user@test.sqlserver.database.windows.net:1433/Configuration {100800E423}>
2024-09-13T04:19:49.130000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://usern@postges-poc.postgres.database.azure.com: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
The text was updated successfully, but these errors were encountered:
migrate.load file data:
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://user@test.sqlserver.database.windows.net:1433/Configuration {100800E423}>
2024-09-13T04:19:49.130000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://usern@postges-poc.postgres.database.azure.com: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
The text was updated successfully, but these errors were encountered: