SSRS Report to show differences between 2 databases

i have of weird requirement, , thought ask community see if has done before, , perhaps assist.

i have several sql environments particular system (prod, dev, test etc) , out of sync in way of data, more importantly, changes made sps, views , other objects can pain find. use redgate's sql data compare, or built-in features of visualstudio compare of objects, looking @ building ssrs report if possible, outline objects different, , 1 drill down on object, show actual differences. example:

database 1 dbo.somestoredproc dbo.someotherstoredproc

database 2 dbo.somestoredproc dbo.someotherstoredproc

clicking on "dbo.somestoredproc" drill-down, , show cell have source sp on 1 side, , target sp on other, or that.

can give me few ideas started?

hi taylor,

according description, want create report show difference in records between source database , updated database. right?

in reporting services, can use lookup() function return fields dataset. in scenario, need create 1 dataset each database data. since data in 2 database support have same part, can use use lookup() function based on same column in 2 datasets return column might updated. can compare return column column in current dataset , return different value , use filter keep rows need. have tested scenario on our local environment, please refer steps below:

1. create 1 dataset each database data.

2. add calculated field in dataset1. use expression below:

=iif(fields!col2.value<>lookup(fields!col1.value,fields!col1.value,fields!col2.value,"dataset2"),"1","0")

3. can add filter filter records return values "1".

reference:
lookup function (report builder , ssrs)

if have question, please feel free ask.

best regards,
simon hou

SQL Server  >  SQL Server Reporting Services, Power View