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