跨实例导入/导出 Sql Server 2005 用户/权限的简单方法？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/803386/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Easy way to import/export Sql Server 2005 users/permissions across instances?
提问by John Farrell
Is there an easy way to export and then import users/permissions from one Sql Server 2005 instance to another?
是否有一种简单的方法可以将用户/权限从一个 Sql Server 2005 实例导出然后导入到另一个实例？
采纳答案by littlechris
Use the management console to generate a script for your users and thier associated permissions. Same can be done for the server logins in the security folder.
使用管理控制台为您的用户及其相关权限生成脚本。安全文件夹中的服务器登录也可以这样做。
Select your user: Select DB and expand security\users folder Right Click --> Script User As --> Create To --> New Query
选择您的用户：选择 DB 并展开 security\users 文件夹右键单击 --> Script User As --> Create To --> New Query
For Logins
对于登录
Select your Login: Expand security\logins folder Right Click --> Script Login As --> Create To --> New Query
选择您的登录名：展开 security\logins 文件夹右键单击 --> 脚本登录为 --> 创建到 --> 新建查询
Now just run the query on your new instance. Just choose the db to run the script in.
现在只需在新实例上运行查询。只需选择要在其中运行脚本的数据库。
回答by Kolten
Might need to do a "sp_change_users_login AUTO_FIX, 'my_user'" afterwards to re-link security logins to their respective data as well.
之后可能需要执行“sp_change_users_login AUTO_FIX, 'my_user'”以将安全登录重新链接到各自的数据。
回答by user238571
sqlcmd -E -d master -S suksql01 -Q "sp_help_revlogin" -o \suksql03\login\LOGIN.txt go exec sp_help_revlogin go
sqlcmd -E -d master -S suksql01 -Q "sp_help_revlogin" -o \suksql03\login\LOGIN.txt go exec sp_help_revlogin go
exec sp_help_login
执行 sp_help_login
