SQL Server: Easiest way to copy users from dev -> prod

What is the easiest way to move (copy) users from dev database to prod database?

Answers


Select the "Users" node in Object Explorer, Bring up "Object Explorer Details" from the View menu. Select all, Right Click, "Script User as..."

Review script and change any logins as required to refer to logins on the production server.


Need Your Help

how can I set an empty mvn property in m2eclipse?

m2eclipse maven-surefire-plugin

I want to make a mvn run-configuration in eclipse/m2eclipse. I want to mimic the following mvn command:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.