Come across an interesting situation; one application is connecting to 2 different databases, where as it should connect to only one, now how to figure it out, which one is the good & correct one.
Application has different kind of users, some accessing one db, but others 2nd db, now need to figure it out, which one is the good and acceptable one.
Please advise/suggest, what should be the best possible course of action, in order to figure it out, which one is the correct one.
Need to proof this from different perspectives; data/changes, active/logged in sessions and DDL basis too.
Please guide, thanks in advance.