Compare values in sys tables

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Compare values in sys tables

Postby wdhenrik » Thu Jun 13, 2013 1:01 am

I want to compare some SQL Agent job definitions in the MSDB database.

SQL Compare can't see them because they are not "objects" and SQL Data Compare doesn't see the sys tables.

Any suggestions? It will save me a lot of time if i can use one of the comparison tools for this.

Thanks,
Wes
wdhenrik
 
Posts: 12
Joined: Thu Jul 19, 2012 11:58 pm

Postby eddie davis » Thu Jun 13, 2013 11:28 am

Hi

Thank you for your forum post.

You cannot compare system objects or sys tables using SQL Compare or SQL Data Compare, which means you cannot compare SQL Agent job definitions. Sorry.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby wdhenrik » Thu Jun 13, 2013 4:53 pm

Please add comparing sys tables into the options menu. I can understand why you wouldn't want them to be included in the default settings, but this could be very useful.
wdhenrik
 
Posts: 12
Joined: Thu Jul 19, 2012 11:58 pm

Postby eddie davis » Fri Jun 21, 2013 10:03 am

Hi

Thank you for your reply.

I recommend that you add a comment and place vote in this SQL Data Compare User Voice Forum TOPIC.

The User Voice fourm provides the means for other users to see the Feature Requests received and vote for their favourite suggestions.

The more votes a topic receives, will increase the chances of it appearing in a future version of the product.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests