How to use SQLSnapper with TrustCertificate=True in the connection?
martinm
Posts: 3 Bronze 1
in SQL Compare
In the SQLSnapper GUI there is no option/checkbox to enable Trust Server Certificate. Do you have instructions how to modify the xml config file to include this option?
Best Answer
-
martinm Posts: 3 Bronze 1I was able to do this successfully using the command line interface, using the following one-liner, saved to a .BAT file:
RedGate.SQLSnapper.exe /database:MyDatabase server:"MyServer,port;encrypt=true;trustservercertificate=true" /mksnap:MyDatabase.snp
This seems to work only in the command line interface. Redgate - Please add this feature to the GUI in the stand alone SQLSnapper UI (this option already exists in the full product SQL Compare -> Snapshot utility, just not in the stand alone SQLSnapper). Pretty, pretty, please.
Answers