Skip to content
← SQL Data Compare

How can we improve SQL Data Compare?

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

51 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Wes shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • VladX commented  ·   ·  Report

    This would be very helpful.

  • Paul R commented  ·   ·  Report

    Agreed! Please add this. Then we can compare job info!

  • Anonymous commented  ·   ·  Report

    I tried to do this today and indeed surprised that you can't compare msdb data. Would be handy.

  • Anonymous commented  ·   ·  Report

    I'm really surprised there's no way to compare or sync jobs between databases.
    I could really use this.

  • len commented  ·   ·  Report

    IF [NOT] EXISTS Checks.
    For Data inserts.

    Re run scripts