Compare and synchronize indexes in SQL Server databases

Indexes
Parameters of comparison and synchronization for Indexes in SQL Server databases, including comparison by definition for Table Indexes, View Indexes and XML Indexes

Common parameters

SORT_IN_TEMPDB

Use the option "SORT_IN_TEMPDB" to create indexes.

Table Indexes

Compare and synchronize Table Indexes.

Create

Create new ones, if they are not defined for the table of 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 are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.

View Indexes

Compare and synchronize View Indexes.

Create

Create new ones, if they are not defined for the view of 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 are not defined for the view of the template database. Removal will not take place, if the view does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.

XML Indexes

Compare and synchronize XML Indexes.

Create

Create new ones, if they are not defined for the table of 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 are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.