I am afraid that there may be a lot of bugs in the procedure to fix up due to the script complication and I was already told that the way the results are returned is not clear and intuitive but anyway thank You very much for kind words 🙂
> I have a similar situation with two databases that exist on different servers.
> Is there a way to use this script to compare two databases with the same name on different servers?
I think it would be possible to prepare similar script to compare databases on two different servers:
- one way: via linked servers, the script would have to accept linked server beside database name and modify all queries to use them but I haven't tested this solution yet so I do not know if it can work
- second way: to incorporate OPENROWSET clause in all queries and give extra parameters to the procedure so that You can provide a connection string and provider name
- another way: I have no idea what it would be like but I am sure there exists any
I will try to prepare such script as soon as I can.