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.
Rich Etheridge commented
Frank DeWysockie commented
Agreed, this would be helpful
This would be very helpful.
Paul R commented
Agreed! Please add this. Then we can compare job info!
I tried to do this today and indeed surprised that you can't compare msdb data. Would be handy.
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