Untrusted Certificate


I was able to sync data between two databases using the GUI and getting started with automating SQL Data Compare. There is a checkbox in GUI to "Trust server certificate" and the sync worked. Now I am trying to use /Argfile with an XML. How to I tell it to trust the certificate?

PS C:\Program Files (x86)\Red Gate\sql data compare 15> .\sqldatacompare /Argfile:d:\DataRepository\DailyBackups\RedGateSync\ArgXMLFile.xml

SQL Data Compare V15.0.2.22953
Copyright c Red Gate Software Ltd 1999-2023

SQL Data Compare: activated, edition professional, serial number: Licensed

Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

<?xml version="1.0"?>

Is there a complete list valid switches and options? Documentation is very limited.

Thank you!


Sign In or Register to comment.