Page History

...

1. Open the IDERA SQL Admin Toolset Launchpad, and then click User Clone.
2. Specify the SQL Server login you want to clone and the SQL Server instance where this login is located. By default, User Clone lists the available logins on the specified instance.
3. Specify the SQL Server instance and database where you want to create the new login. The new login name is the same as the source login name.
4. Select which security properties you would like to clone.
5. To perform the clone operation immediately, click Clone User.
6. If you want to create a T-SQL script based on your settings, choose the appropriate action based on the version of SQL Server you are running.
7. If you want to save the script, copy the code to clipboard, or save the code to a file.

IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >