The User Clone tool helps you create new logins by copying an existing SQL Server user and using that login as a template. You can immediately perform the clone operation through the tool, or generate a T-SQL script that you can preview and edit.
Use the User Clone tool to create new user accounts from an existing account. You can copy a SQL Server login across SQL Servers and keep the same access settings and specify a new default database or password during the clone. After creating a new account, you can set the new SQL Server login as enabled or disabled.
Another new function is that you can generate a T-SQL script that you can integrate into your existing work flows.
By default, User Clone connects to the specified SQL Server instance using the credentials of your currently logged on Windows account. The User Clone tool then copies the specified source SQL Server login and recreates it on the target SQL Server instance and databases. By default, the new login shares the same password, server and database roles, permissions and database access of the source login.