How to make sql compare remember passwords?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

How to make sql compare remember passwords?

Postby DanAvni » Mon Sep 03, 2012 10:12 am

using the latest version of sql compare, how do I make it remember users & passwords for the various sql servers I am using?

each time I select on the compare dialog a new server I need to enter the sql authentication user & pwd again. I want to just tell sql compare the login credentials once and be done with it for ever.
Dan Avni
DanAvni
 
Posts: 48
Joined: Wed Jun 15, 2005 12:55 pm

Postby andy.campbell.smith » Wed Sep 05, 2012 2:58 pm

When you set up the comparison for the first time with the comparison wizard, there should be a tickbox called 'Save password' - does that not show up for you?

Image
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby andy.campbell.smith » Wed Sep 05, 2012 3:05 pm

Wait, hang on - I'm not sure I've understood you. You say each time you select a new server you need to enter the credentials again - SQL Compare can't tell if you use the same credentials between servers, so you won't be able to make it autofill credentials for a server it hasn't seen before.

If you only have SQL authentication on your servers, I'm afraid you'll have to enter the username and password every time you start a new comparison. If you're commonly comparing a certain pair of databases, though, you can save the comparison as a project, and if you ticked the 'save password' box while setting it up you won't need to re-enter credentials for that comparison.

Does that answer your question a little better?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby DanAvni » Wed Sep 05, 2012 3:47 pm

Please add a feature like the "Server registration" in SSMS. In SSMS, I register the server once and never again have to remember the password.

I have a lot of DB servers I am connecting to and a lot of databases to compare. Instead of opening a project for every pair, I usually use one project and replace one side of the comparison (the other side is a usually a dev db). on some occasions, I need to compare the dev db to a snapshot or to a backup (again still using the same comparison project as before). after comparison to a snapshot If I need to then compare to a live DB I need again to enter the credentials.

I know I am not using sql compare in the way you planned (with comparison projects) but I find my way much easier for my needs.

in short I think a feature like "server registration" would make life easier in usage cases like mine
Dan Avni
DanAvni
 
Posts: 48
Joined: Wed Jun 15, 2005 12:55 pm

Postby andy.campbell.smith » Wed Sep 05, 2012 4:05 pm

Sure, OK - we're always eager to hear about users who have come up with workflows that we didn't anticipate, so thanks.

Can I ask you to post this as a feature suggestion on our UserVoice forum? It's easier for me to convince the development team to implement features if I can show them a submission with a lot of backing on UserVoice - if you've got a minute, it'd be great if you could have a look around and vote on any other features you think would be good in the tool. Thanks for your feedback!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests