Idera SQLpermissions is a freeware tool for copying or moving logins and permissions settings across SQLservers. SQLpermissions automates the time-consuming job of configuring logins and permissions on one server to match another by generating a customizable T-SQL script to do this for you. SQLpermissions also offers the flexibility to move one login or a group of logins and apply permissions across all databases on the target server, or a single database. It will also provide you with a simple view of all logins and permissions on your SQL Server. SQLpermissions supports Microsoft SQL Server 2000 (SP3a+) and provides limited support for SQL Server 2005 (SP1+.) It does not install any code on the database server.
Moving permissions from one server to another is a pain to do manually, so a tool like SQLpermissions can save DBAs lots of time and reduce errors, helping to ensure that security levels are maintained when setting up new SQL Servers. All the support materials that you need to install, configure and use Idera Freeware tools are provided via FAQs on the Idera website.
SQLpermissions has been developed by the engineering team at Idera to alleviate the common headache that many SQL Server DBAs face when moving and copying logins permissions ? please enjoy!