Samuel:

My hand goes out to Steve. I should have thought your request through further. I would never merge three separate legal entities into one database.

In my example my client was a single legal entity operating in three locations. They should never have had separate databases in the first place.