Create Excel report
Make the comparison/synchronization report in Excel.
Report database schemas differences to Excel
The synchronization protocol of a task being executed is reported to Excel as a compound list of objects, properties, and other comparable entities of both databases with the results of their comparison, required sync actions and their reasons. Depending on the specified task options the report represents a comparison, deploy simulation, or actual synchronization of two SQL Server database schemas. It is generated each time when the Compare with and Create Excel report options are set.
Report columns
- Result
- Comparison result
- Action
- Actions to be performed on this object
- Type
- Object type
- Schema
- Object schema, if any
- Parent/Grantor
- Parent object for child objects or security principal grantor for permissions
- Name
- Object name
- Reason
- The first reason of Action
Excel report example
Comparison report vs Synchronization report
Since the report is based on the synchronization protocol - a list of actions on objects of the target database, you should work with it through them (through actions).
To get a comparison report that reveals all the differences of database structures you must allow all actions on objects in the task settings except for group ones. Also, in this case, we do not need the Resolve dependencies and Resolve conflicts options.
To get a synchronization report configure the task the way you want to sync. Turn on the Resolve dependencies and Resolve conflicts options. They will unwind chains of dependent objects.
Use Typical Presets from the task document menu to have it done quickly.