search

dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.45k stars 548 forks source link

Unnable to use MSSQL as a source : #1571

Closed loicdesguin closed 2 weeks ago

loicdesguin commented 7 months ago

Hello,

I try to use pgloader to migrate data from mssql to postgresql but I'm facing an issue with the configuration of the source

ERROR mssql: Failed to connect to mssql at "localhost" (port 59256) as user "sa": Connection to the database failed for an unknown reason.

There is not a lot of details in the log or in the console despite --debug and --verbose option.

from mssql://sa:password@localhost:59256/test

So my question, how to retrieve details about the error ?

Best Regards

Loïc

ByZhouhang commented 2 months ago

Hello,

I try to use pgloader to migrate data from mssql to postgresql but I'm facing an issue with the configuration of the source

ERROR mssql: Failed to connect to mssql at "localhost" (port 59256) as user "sa": Connection to the database failed for an unknown reason.

There is not a lot of details in the log or in the console despite --debug and --verbose option.

from mssql://sa:password@localhost:59256/test

So my question, how to retrieve details about the error ?

Best Regards

Loïc

iI'm having the same issue, did you find a way to fix it?

loicdesguin commented 2 weeks ago

Hello, I had to define a source database in the /etc/freetds/freetds.conf file : I was not able to define the full configuration on the .load file.