SSIS Catalog Compare 2019

SSIS Catalog Compare 2019 is ready to lift and shift your enterprise SSIS to the cloud!

“How can I know my SSIS Catalog in Production matches my QA Catalog or my Azure Data Factory SSIS Integration Runtime?”

“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 in 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.” – ETL Architect

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

“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.” – Enterprise Data Engineer

New Editions!

There are two editions of SSIS Catalog Compare available:

  1. Standard
  2. Enterprise

SSIS Catalog Compare Community Edition?

People often as, “Is there a free or Community Edition of SSIS Catalog Compare available?” The answer is, “Yes!” SSIS Catalog Browser shares the SSIS Catalog viewer functionality – the unified surface – with SSIS Catalog Compare. SSIS Catalog Browser is free.

SSIS Catalog Compare Standard Edition

SSIS Catalog Compare Standard Edition includes the following functionality:

  • Unified surface to view SSIS Catalog artifacts
  • Compare configurations metadata in two SSIS Catalogs
  • Generate scripts and ISPAC files for SSIS Catalog artifacts, including:
    • Catalog Folders
    • SSIS Projects (and Packages)
    • Catalog Environments and Environment Variables
    • SSIS Project (and Package) References and Reference Mappings
    • SSIS Project (and Package) Literals
  • Deploy SSIS Catalog artifacts (listed above) between SSIS Catalog instances – including Azure-SSIS. You can use SSIS Catalog Compare to “lift and shift” enterprise SSIS to the cloud.

Contact us for more information about SSIS Catalog Compare Standard Edition.

SSIS Catalog Compare Enterprise Edition

SSIS Catalog Compare Enterprise Edition includes the all Standard Edition features (listed above) plus SCCPAC deployment packaging.

  • Script generation includes SCCPAC file creation
    • SCCPAC files contain all artifacts associated with a Catalog Folder
  • SCCPAC files may be deployed using the new SCCPAC Deployment Wizard:

Contact us for more information about SSIS Catalog Compare Enterprise Edition.