Results from SQL Data Compare of msdb

webrunner · June 19, 2017 3:47PM

Hello experts,

I have tried SQL Data Compare 12 with the msdb database on two different servers and get blank results. I mean totally blank - not a list saying all data is identical.

Does anyone know how to do this comparison correctly? Does it have to do with the permissions of the login being used to do the comparisons?

Thanks for any help.

Jessica R · June 23, 2017 11:53PM

Hi @webrunner!

Is this from the command line or the SQL Data Compare UI?

If you go to Edit Project >Tables and Views, are the objects you want to compare selected and has a comparison key been set for each set of mapped objects?

cfradenburg · December 7, 2017 8:29PM

I ran into the same issue using both the GUI and command line. SQL Data Compare appears to filter out system and is_ms_shipped objects when comparing. While that makes sense in most cases it would be a useful tool for comparing several things in msdb.

sam.blackburn · December 11, 2017 1:51PM

You're correct that Data Compare ignores most objects with the is_ms_shipped flag. There are workarounds for this (e.g. create a view for each of the tables in question and enable the Include Views option) though if you'd love to see this feature, I recommend that you upvote the idea on uservoice: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/2897256-i-would-like-to-use-sql-compare-to-compare-system

cfradenburg · December 11, 2017 2:20PM

Sam,
Thanks for the response. I'll give the views a try.
Chris

Results from SQL Data Compare of msdb

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk