“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.”
– an ETL 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.”
– an Enterprise Data Engineer
“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
“Can I automate syncing a Catalog Folder in one Catalog with another?”
The command line below 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.