Compare Sys tables - I want to compare SQL Jobs
Please add an option to make the Sys tables available for comparison. I want to compare SQL Agent Job definitions in the MSDB database. At this time, SQL Data Compare and SQL Compare cannot do this. Everytime I have to promote jobs to a new environment, I have to do a manual comparison of the SQL Job defintion. Very tedious.
I'm really surprised there's no way to compare or sync jobs between databases.
I could really use this.
IF [NOT] EXISTS Checks.
For Data inserts.
Re run scripts