Red Gate forums :: View topic - Compare values in sys tables
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Compare values in sys tables

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
wdhenrik



Joined: 19 Jul 2012
Posts: 12

PostPosted: Thu Jun 13, 2013 1:01 am    Post subject: Compare values in sys tables Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Thu Jun 13, 2013 11:28 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
wdhenrik



Joined: 19 Jul 2012
Posts: 12

PostPosted: Thu Jun 13, 2013 4:53 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Fri Jun 21, 2013 10:03 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group