pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

MSSQL connection string format

Open MadhuPristine opened this issue 1 year ago • 1 comments

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

MadhuPristine avatar May 29 '24 08:05 MadhuPristine

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@@[email protected]/sqlserver2014,1436

ffried avatar May 29 '24 12:05 ffried