You can compare server or database settings of two Microsoft SQL Server databases. This operation is only available for Microsoft SQL Server (all versions are supported).
Select the operation scope by choosing the desired nodes on metadata trees.
Click the Compare settings button to start the operation.
The result of server settings comparison includes the following groups:
Operation system properties;
The result of Database setting comparison includes a couple of groups:
System database properties.
As a result, you’ll be able to compare server or database settings on one screen. Note that in both cases the differences will be highlighted in red (see the picture above).
Click the Export button at the bottom right-hand corner of the central window to save the settings comparison result into the .csv file.
Check the Export only differences option to save only the differences.
Click the Close button at the top right-hand corner of the central window to close the Settings comparison window.