Blog

When I’m using mysql client, I can configure my db credentials in ~/.my.ini. How can I achieve similar thing with sqlcmd on Linux? Where and what filename I should create? My goal is to avoid keep repeating hostname, user and passwords for every command.Read more

I have an sql script that uses select object_defintion(object_id(…)) to extract the definition from a view. This script is run with sqlcmd: sqlcmd -i extract.sql -o %oudir%\extracted.dat. Unfortunately, the length of the returned string seems to be truncated so that not the entire view definition is extracted. Is there a possibility to extend the lengthRead more