search

dimitri / pgloader

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

MSSQL connection string format #1584

Open MadhuPristine opened 4 months ago

MadhuPristine commented 4 months ago

Hi, I'm not able to connect with MSSQL having servername 192.168.01.12\sqlserver2014,1436 username sa and password test@123. Can anyone help me to find how to specify source with above details

Regards Madhu

ffried commented 4 months ago

It's stated in the docs: https://pgloader.readthedocs.io/en/latest/ref/mssql.html Since you have an @ in your password, please also have look at the connection string section, which explains how to escape such special characters: https://pgloader.readthedocs.io/en/latest/command.html#connection-string

If I understand your comment correctly, it'll probably be mssql://sa:test@@123@192.168.01.12/sqlserver2014,1436