“Can I automate syncing a Catalog Folder in one Catalog with another?”
CatCompare Version 2.0 is a CLI (Command-Line Interface) utility for SSIS Catalog Compare functionality. CatCompare facilitates DevOps with SSIS.
Deploying SSIS Catalog Projects is easy. Maintaining environments, references, and literal overrides between SSIS Catalogs is hard. Schedule a CatCompare command line to execute each night to migrate the contents of a Development SSIS Catalog to an Integration SSIS Catalog. For example, this command line will start CatCompare, load the SSIS Catalog hosted on the SQL Server instance named vmSql16\Dev, load the SSIS Catalog hosted on the SQL Server instance named vmSql16\Test, and compare the Catalog contents. Detected “differences” will be deployed from the Demo Catalog Folder on vmSql16\Dev to the Catalog Folder named Demo on vmSql16\Test. The results of the deploy operation will be redirected to a file: E:\Test\CatCompare_DeployFolderDiffs_Results.txt. And then CatCompare will exit.
CatCompare costs only $295 USD.
Your purchase includes one year of maintenance upgrades – a $95 value!