There doesn’t seem to be a way to create encrypted MS SQL Server connections natively within scriptcase as you can with say MySQL. The option in scriptcase simply doesn’t exist like it does for MySQL. Is it possible to do this without creating an ODBC connection? PDO allows you to create connection info which enables encryption so theoretically it’s possible…
Our business is strict on secure development so we have to make everything is secure and encrypted where possible.
I can achieve encryption if I use the SQL Server ODBC driver by enabling “use strong encryption for data” but it’s adding an extra level of complexity and then another level for docker containers, CI pipelines and so on… it’d be better if it could be handled centrally within scriptcase.
Any tips would be appreciated.