How to Install/Renew certificate via script after change to SQLite?

Question

Since CompleteFTP now uses SQLite, the Powershell script previously in use for certificate update needs to be updated to use SQLite.  However, I need to know if the same SQL command will work, or if things have changed with regard to the schema with the transition to SQLite?  I'd like to have a working solution BEFORE I upgrade to the latest version.

This is the update command that worked with SQL Server Compact.  Will it work with SQLite (provided that the connection is correct)?

"UPDATE Site SET SSLCertificate = @HexString, SSLCertificatePassword = @Pass"

Also, this is the previous location/file name.  What is the new location/file name?

"Data Source = C:\ProgramData\Enterprise Distributed Technologies\Complete FTP\config.sdf;"

Answer 1

The UPDATE query should work as is. Our installer runs queries using the same syntax and they work fine.

The Data Source is:

"Data Source = C:\ProgramData\Enterprise Distributed Technologies\Complete FTP\config.db;BinaryGuid=False"

The BinaryGuid thing probably isn't necessary unless your queries use GUIDs.

You might like to install the CompleteFTP trial on another machine and test your script on its DB before using it in production.