6 October 2017
6 October 2017

Remembering passwords in SQL Compare and SQL Data Compare

We’ve recently added a feature to automatically populate your SQL Server credentials when you’re using SQL Compare or SQL Data Compare. If you check the Remember credentials box, passwords will now be stored in two places: the Windows Credential Store and your project file if you save one.

The project file has long been a way to share comparisons and you can still save your credentials there. However, this doesn’t do the whole job if you often make the same comparison between many different environments, tediously entering the password for each server when you edit the project.

Enter the Windows Credential Store: if you choose to save your password, it will now be stored here even if you don’t save a project. This means it can be filled in automatically next time you connect to the same server from SQL Compare or SQL Data Compare.

The Credential Manager in the Windows Control Panel has a tab called Windows Credentials where you can manage credentials saved by many applications. The ones saved by SQL Compare and Data Compare have names like Redgate SQL Connection [MyServer] and you can delete any you don’t want from there. (Side note: the stored value is actually a connection string to support different authentication methods. If your password changes, it’s easiest to re-enter it in the Edit Project dialog).

SQL Comapre password 2

If you don’t want any new passwords to be stored, just ensure the Save password box in the Edit Project dialog is unchecked. This will disable both types of password storage, so passwords will not appear in the Credential Store and your project files will be safe to distribute.

It’s the sort of feature you might have used without even noticing. SSMS and SQL Doc have remembered passwords for a long time now, and it was a popular suggestion on the SQL Compare UserVoice page. If there are other features you’d like to see in SQL Compare or SQL Data Compare, please let us know.

Tools in this post

SQL Compare

Compare SQL Server schemas and deploy differences fast.

Find out more

SQL Data Compare

Compare and deploy SQL Server database contents.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

You may also like

  • Article

    Using SQL Compare with Row Level Security

    SQL Server 2016 brings with it a host of new features that will be both useful and appreciated by many customers. Quite a few of these features relate to providing additional security for databases, one of which is Row Level Security (RLS). This is a feature that has been available in Azure SQL Databases for

  • Article

    Deploying schema changes to multiple databases using the SQL Compare command line

    Sometimes, you need to synchronize multiple target databases with the same source database, or with the source code for that database, in version control. You may need to push out the schema changes to ten copies of the database on ten different servers, as part of a deployment, for example. Or there may be cases

  • Article

    Keeping track of history: SQL Compare and Temporal Tables

    SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for that table, will be included automatically in any deployment script that SQL Compare generates

  • Article

    Automatically keeping 'hotfix' and production database schemas in sync

    In this article, I’ll be showing you how to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. In other words, for any database object that exists in both databases but with differences, the object’s definition in the

  • Article

    Introducing the updated HTML comparison report in SQL Compare 13.1

    Whether you need to deploy changes, or simply view the differences between two SQL Server databases, SQL Compare helps you do the job quickly and accurately by exploring what’s changed in each database object, down to individual lines of SQL. In SQL Compare 13.1, we’ve updated the interactive HTML comparison report type, providing simpler cleaner

  • Forums

    SQL Compare Forum

    Forum for users of SQL Compare schema synchronization utility