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

Security
Parameters of comparison and synchronization of database security principals

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.

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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.

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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 template 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.

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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 template database.

Ownerships

Compare and synchronize Ownerships.

Restore

Restore the ownership of database objects, if they will be lost during the rebuild of the object.

Alter

Alter the ownership of new and existing database objects.