Compare and synchronize logins, users, groups, roles, schemas and ownerships of SQL Server databases

Comparison and synchronization settings for database security of two SQL Server databases: Logins, Users, Roles, Rolemembers, Application Roles, Schemas, Ownerships

Common parameters

Use Blank123!!! as password

Use "Blank123 !!!" as a literal password for creating logins, users and application roles instead of generating a new random password each time as it is by default. This option will be useful in comparative analysis or if you want to edit passwords in the result script before execution.

Logins

Compare and synchronize Logins.

Create

Create new ones, if they do not exist in the target database.

Parameters

Parameters of the comparison and synchronization, and the export to the database structure file for Logins.

Owners only

Logins of the users who own any objects in the database or the database itself.

All

All database user logins.

For entire server

All server logins.

SID

Use the SID values.

Hashed values of passwords

Use the hashed values of the passwords instead of the temporary password 'Blank123!!!'.

Users

Compare and synchronize Users.

Create

Create new ones, if they do not exist in the target database.

Alter

Alter existing ones to remove the differences.

Recreate

Recreate (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they do not exist in the source database.

Parameters

Parameters of the comparison and synchronization, and the export to the database structure file for Users.

Owners only

Users who own any objects in the database or the database itself.

All

All database users.

SID

Use the SID values.

Roles

Compare and synchronize Database-Level Roles.

Create

Create new ones, if they do not exist in the target database.

Recreate

Recreate (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they do not exist in the source database.

Rolemembers

Compare and synchronize Role members.

Add

Add new ones, if they do not exist in the target database.

Drop

Drop existing ones, if they do not exist in the source database.

Parameters

Parameters of the comparison and synchronization, and the export to the database structure file for Role members.

All

All role members.

Application Roles

Compare and synchronize Application Roles.

Create

Create new ones, if they do not exist in the target database.

Alter

Alter existing ones to remove the differences.

Recreate

Recreate (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they do not exist in the source database.

Schemas

Compare and synchronize Schemas.

Create

Create new ones, if they do not exist in the target database.

Drop

Drop existing ones, if they do not exist in the source database.

Ownerships

Compare and synchronize Ownerships.

Restore

Restore ownership of database objects if they will be lost during the objects recreation.

Alter

Alter owners for new and existing database objects.