开发者

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

开发者 https://www.devze.com 2023-01-28 14:59 出处:网络
What is the 开发者_StackOverflow中文版easiest way to move (copy) users from dev database to prod database?Select the \"Users\" node in Object Explorer, Bring up \"Object Explorer Details\" from the Vi

What is the 开发者_StackOverflow中文版easiest way to move (copy) users from dev database to prod database?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消