What are the challenges you face when working across database platforms? Take the survey
Options

Dealing with passwords in SCA projects

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.
Tagged:

Best Answer

  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com

Answers

  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.