Red Gate forums :: View topic - How to make sql compare remember passwords?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

How to make sql compare remember passwords?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DanAvni



Joined: 15 Jun 2005
Posts: 47

PostPosted: Mon Sep 03, 2012 10:12 am    Post subject: How to make sql compare remember passwords? Reply with quote

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
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Sep 05, 2012 2:58 pm    Post subject: Reply with quote

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?


_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Sep 05, 2012 3:05 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
DanAvni



Joined: 15 Jun 2005
Posts: 47

PostPosted: Wed Sep 05, 2012 3:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Sep 05, 2012 4:05 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group