Untrusted Certificate

tekpmb

Hello,

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"?>

<commandline>

<database1>SourceDB</database1>

<server1>RemoteServer</server1>

<username1>userid</username1>

<password1>password</password1>

<database2>LocalServr</database2>

<server2>LocalDB</server2>

<sync/>

<include>Table:[table1]|[table2]|[table3]</include>

</commandline>

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

Thank you!

DanC

Hi @tekpmb

Strange that it's not documented in the SDC specific command line documentation, but you can add the trustservercertificate parameter to the server switch in the xml file I suspect

https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line

/server1:"Widget_Server\SQL2008,<port>;encrypt=true;trustservercertificate=true"

Tromeen

To instruct SQL Data Compare to trust the server certificate when using the /Argfile option with an XML file, you can include the necessary settings within the XML configuration.