You don't have a batch of source data; you have individual files. Each one needs to be read. You could bulk insert these into a staging table, then do the...

I found a reference here that notes a trigger on the CDC table causes issues: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/af412328-7855-4f3c-8059-7861ac2e6531/is-it-sensible-to-use-a-trigger-on-a-cdc-change-table?forum=transactsql
There's also a note in the CDC docs that says the table...

Good comments, and thanks. Note, I'm not looking to rewrite an entire project or a huge section. Just rewrite the code (or some of it) from yesterday.

That's why they weren't in the question 😉

🙁

SQL Compare will produce the CREATE syntax for both objects and then give you the differences as most Version Control Systems do. Here is a view of two different procs...

On the download pages, apparently on Docker. Ran a quick apt-get, hadn't see an update yet for Linux.