We require a script to merge two databases.
This script will then be used on site (whenever required) to merge the live databases. The databases have the exact same schema, only the data that is different.
The databases consist of about 53 tables.
There is very little synchronisation required (maybe just to common entities such as the Admin user) as the databases have been used at separate sites.
The end result should be a script which merges any two of our databases.
I expect quite a bit of communication may be required to understand the database, although hopefully, much of it will be obvious.