Using SSIS Catalog Compare to Migrate SSIS Catalog Folders

SSIS Catalog Compare 2022 (Beta) is available at a dramatically-reduced yearly subscription rate at the time of this writing. The yearly subscription rate will increase when SSIS Catalog Compare becomes generally available (GA). Those willing to help out by testing the beta version (in Development and Test environments only, please!) will enjoy the beta yearly subscription rate post-GA.

In this video, I describe and demonstrate how to use SSIS Catalog Compare to compare an on-premises SSIS Catalog instance to an SSIS Catalog instance that serves as the SSIS Catalog for an Azure Data Factory Azure-SSIS integration runtime, hosted on an instance of Azure SQL DB. I then migrate one SSIS Catalog Folder – including an SSIS project, environments (and environment variables), configured literals, references, and referenced (parameter) mappings – from on-premises to the cloud in a few clicks.

Enjoy!

:{>

Andy Leonard

andyleonard.blog

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

One thought on “Using SSIS Catalog Compare to Migrate SSIS Catalog Folders

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.