How do I use SQLpermissions to copy permissions from one server to another?
SQLpermissions generates a customizable TSQL script to move user logins and permissions from one server to another. To generate the TSQL script, follow these easy steps: • Install and launch SQLpermissions • Select a login method • If you select SQL Server Authentication, please enter your username and password. • Select (or type in) the name of the SQL Server that you want to copy permissions FROM • Select (or type in) a single database name or select ALL for database(s) that you want to copy permissions FROM. • Select the User account whose permissions you would like to copy. Use CTRL + Shift to select multiple accounts. • Click “Generate” to produce the TSQL script. You will be prompted to enter a path and file name where you would like to save the script. You can then edit the TSQL script as needed to customize it further. • To run the TSQL script, locate the saved SQLpermission.sql file. • Move the file to the server where you wish to replicate the user logins and permissions. • D
Related Questions
- How do I fix a "No permissions to backup exchange server or the store was not mounted" condition ater getting a system notice?
- I am going to register a new server. What are the guidelines for file access and directory permissions?
- How can I create a copy of a catalog on the ZENworks Linux Management Server?
