compare SQL query results from two different servers

(0) Share

Report

Posted on by amcneil32

167

I have two SQL queries that are running against two separate SQL instances (servers). I need to take the values returned, find the difference in them, and depending on that result send an email. My plan is to have these queries scheduled and sent to my inbox (SSRS). I can create a flow for each query to look in my inbox and create a OneDrive excel file. I would need an additional flow to take these results when their files are created and compare them, like below. Last, on one of the email conditions I would need to attach a pdf report. That report is sent automatically as well, so I think I would need an additional flow to upload that to OneDrive. Is there a more efficient way to approach this problem? I know multiple triggers aren't supported in single flows, but having to create this many flows seems a little difficult to manage.

note: The data is on premises and I do not have a data gateway installed.

All responses (1)

Answers (1)

Verified answer

amcneil32 167 on at

Like (0)

Report

Re: compare SQL query results from two different servers

so I discovered that SSRS can also deliver reports to a windows file share. I downloaded the onedrive app for that which then syncs a local folder to onedrive online. this helped reduce the number of flows i needed to create.