CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2005sql-server-2008
juur
juur

Reputation: 5723

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?

Upvotes: 2

Views: 4263

Answers (1)

Martin Smith
Martin Smith

Reputation: 453426

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.

Upvotes: 4

Related Questions