Export/ Import logins from the source control database.

doliva

Hi,

I have a database on a developer server with some logins there. Now I am using a dedicated database model for any developer in my company but I dont know how I can import for that database the user/login and password to my local database.

Any idea on how can i do this?

Thanks

Manfred.Castro

You will have to modify the comparison options for sql source control.
Directions found here.
http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Source_Control/KB201202000521
You will want to set ignore user properties to false.
<IgnoreUserProperties>False</IgnoreUserProperties>
Information regarding the varying comparison option found here.
http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/sc_project_options

Hope this helps