What is the DILM Suite? 2. SSIS Catalog Compare

SSIS Catalog Compare is really two products: SSIS Catalog Compare (GUI – graphical user interface) and CatCompare (CLI – command-line interface).

This post will focus on GUI functionality as it’s easier to demonstrate.

SSIS Catalog Compare provides the following functionality to enterprise Data Integration Lifecycle Management (DILM):

  • Compares the contents of two SSIS Catalog instances.
  • Scripts the contents of an SSIS Catalog
  • Deploys contents of one SSIS Catalog to another instance

Compare

Consider the following scenario: It’s time to test an SSIS project before deploying to Production. How do you know the SSIS Catalog in QA matches that in Production?

This short video (0:58) demonstrates how SSIS Catalog Compare can detect differences in projects and SSIS Catalog configurations:

Do you need to know QA matches Production? SSIS Catalog Compare provides visual confirmation – and even compares SSIS Catalog Properties.

“I tried to reconcile two SSIS Catalogs for a week. I used SSIS Catalog Compare and was finished in less than one hour.”
– an Enterprise Architect

Script

A difference has been detected. What is the next step? One option is to use SSIS Catalog Compare scripting functionality, available at several levels:

  • Catalog
    • Catalog Contents
    • Catalog Differences
  • Folder
    • Folder and Contents
    • Folder Differences
  • Project (ISPAC)
  • Parameter (Literal) Overrides
  • Environments
    • includes Environment Variables
  • References
    • includes Reference Mappings

In this short demo video, I export the QA version of the SimpleSSISProject SSIS project ISPAC file, then deploy it to Prod:

Do you need to script a complete deployment for the Production DBA or Release Management Team? Scripting is extremely useful for deployments to Production.

“Hey, I demoed Catalog Compare to [a team member] and [another team member] last Thursday and it ended up saving them hours of work. I looked like a hero and so did you.”
– an Enterprise Data Engineer

Deploy

Another option is to use SSIS Catalog Compare deployment functionality, available at several levels:

  • Folder
    • Folder and Contents
    • Folder Differences
  • Project (ISPAC)
  • Parameter (Literal) Overrides
  • Environments
    • includes Environment Variables
  • References
    • includes Reference Mappings

In this short demo video, I deploy the test version of the SimpleSSISProject SSIS project to QA:

Use SSIS Catalog Compare deploy functionality to migrate projects through your enterprise DILM (Data Integration Lifecycle Management) process – until QA and Production. Then use SSIS Catalog Compare to script deployments and have Production DBAs execute the scripts.

“One deployment package took 40 minutes to deploy – given the task to deploy over 400+ SSIS packages – that took a very long time – longer than I had for the deployment of the project. When I found the Catalog Compare tool, it took the deployment of 400 packages to 3-5 minutes per package (or less) with repeatable results on each environment. It’s simple and you can check your code in after you are done or give it to someone else to deploy without lengthy training and explanations on how to deploy the package correctly with variables and environments for each server. It’s a super time-saver with a ‘keep it simple’ front end to compare against development, QA, or Production environment.”
– an ETL Architect

View Only

Catalog Browser surfaces SSIS Catalog folders, projects, literal overrides, environments, environment variables, references, and reference mappings in a single viewer – and it’s the same viewer used in SSIS Catalog Compare. Catalog Browser can be called a “single-Catalog, read-only Catalog viewer.” It shares code with SSIS Catalog Compare but does not include compare, script, and deploy functionality.

Here’s a short video (1:20) demonstrating Catalog Browser functionality:

Catalog Browser is a great way to view the contents of an SSIS Catalog without the need to open additional windows.

In Closing…

As you glean from the videos and customer feedback, SSIS Catalog Compare saves time, headaches, and money for enterprises using SSIS. Please visit the SSIS Catalog Compare page for more information.

Purchase SSIS Catalog Compare today – start saving time, money, and hassle!

Contact us today for more information or to schedule a demo.

You might like working with Enterprise Data & Analytics because we grok the SSIS Catalog.

Learn More:
Expert SSIS Training Online with Brent Ozar Unlimited!
IESSIS1: Immersion Event on Learning SQL Server Integration Services – 2-6 Oct 2017, Chicago
What is the DILM Suite? 2. SSIS Catalog Compare
What is the DILM Suite? 1. SSIS Framework Community Edition
Adding an SSIS Application to SSIS Framework Community Edition
Schedule an SSIS Application with SSIS Framework Community Edition
The Heart of SSIS Framework Community Edition-Parent.dtsx

Enterprise SSIS, Biml, and DILM (recording)
Designing an SSIS Framework (recording)
Biml in the Enterprise Data Integration Lifecycle (recording)
Password: BimlRocks

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, SSIS and Biml guy. I was cloud before cloud was cool. :{>