BI xPress BI Compare

Introduction

Feature IconDescription
BI xPress BI Compare IconThe BI Compare add-in compares two SQL Server objects down to the property level and then displays the results. You can save the comparison, which saves the object paths and filters for easy comparison in the future. You can also export the comparison, which gives you a freeze-frame of the objects at the time that they were originally compared.

Feature Highlights

  • Compare the differences between any SSIS packages
  • The providers for SQL Server and SSAS allow you to read the entire instance specified, including all databases, settings, and logins

Note:  To run a comparison with SSIS packages containing third-party components, the third-party components must be installed on the machine running BI Compare.

SentryOne Workbench must be used when comparing SSIS packages on a machine that only contains SSDT for Visual Studio 2015.

Creating a Comparison Scenario

1. Select BI Compare from the SentryOne Workbench to open the New Comparison Scenario window. Enter a meaningful Name for your comparison, then select Next to continue. BI xPress BI Compare New comparison scenario window

Note:  Name the comparison something that relates to the items you want to compare for easy identification!

2. Select the left hand source type from the Source type drop-down menu. Configure the applicable connection settings for your source type, then select Next to continue. BI xPress BI Compare New comparison scenario select right hand side

Note:  In this example we have selected SQL Server as the source type, and selected the applicable connection string. Each source type has different connection requirements:

Source TypeConnection Requirements
SQL ServerEnter the server name you want to compare, and your permissions (either Integrated or SQL Server Authority).
SSISSelect your packages from the file system, SQL Server, Package Store, or 2012 Integrated Services Catalog.
SSASEnter the server name. Only Integrated Security is available for Analysis Services.
SSRSSelect your report objects from the file system individually, from a folder (to compare several objects at once), or from the web service.

Note:  If the source type you want to use doesn't display, you may not meet the system requirements for that provider. For more information about system requirements, see the System Requirements article.

3. Select the right hand source from the source type drop-down menu. Configure the applicable connection settings for your source type, then select Finish to begin the comparison.BI xPress BI Compare New comparison scenario Finish

Important:  You must select the same source type for both sides of the comparison.

Success: You have created a comparison and are ready to navigate the view!

Navigating the ComparisonBI xPress BI Compare New Comparison

After your comparison has finished loading, one object displays on the left, and the other object displays on the right. Properties that don't match display an x, and objects that exist only on one side or the other are delimited with an arrow pointing to that side.

Note:  Highlighting a line displays the value of the object and highlights the differences between them.

The following toolbar options are available:

BI xPress BI Compare toolbar

ButtonDescription
NewStarts a new comparison scenario.
OpenOpens a previously saved comparison file and starts the comparison.
SaveSaves the current comparison. This generates a file that's used to point BI Compare to the selected targets.

Note:  Saving the comparison only saves the object paths, and not the comparison results. To save the current comparison results, use the Export Results option.
Save AsCreates a new file name from the current comparison.
RefreshStarts the comparison process again and generates updated results.
FiltersSelect to include properties such as ID, StartTime, and StopTime.
Export ResultsCreates a file that records the comparison results at the time of the comparison.
Switch Left/RightSelect a different object for one side of the comparison without having to create a new comparison scenario.
ViewExplicitly filter out the types of comparison results you want to display.
Starting pointsAdjust the left and right starting point for the comparison. By default, the left and right starting point will be set to the root of the source. Adjusting the left and/or right starting points is an excellent way to compare the same item that has been moved from one environment to another.