pgloader
pgloader copied to clipboard
MSSQL connection string format
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
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