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.