Dealing with passwords in SCA projects

Monday

What is the recommended method for handling passwords in SCA projects? For creating users or adding credentials for a linked server, etc. I am using azure devops server and I see that I can use secret variables that will get passed off as SQL CMD variables durring a CI build but it looks like I need to set them in my project as well which is saved as plain text for local builds.

Eddie D

Hi Monday, thank you for your forum post.

Yes, the SCA UI will mask the password characters appropriately. 

However, the password is still stored in plain text in the sqlproj file. Therefore I have added the details of this forum post to existing bug report whose reference is SCA-1469.  Sadly I have no further details as to when a bug fix will become available.  I will update this forum post when I receive further information.

Many thanks
Eddie 

Eddie D

Hi, thank you for your patience.

I am pleased to inform you that Bug Report SCA-1469 is now resolved.  Please Upgrade to the latest version of SQL Change Automation which can be downloaded using this link to the latest SQL Toolbelt installer.  Extract the installer and select the option to upgrade SQL Change Automation.

Many thanks
Eddie