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.
IF [NOT] EXISTS Checks.
For Data inserts.
Re run scripts