I am looking for a way to be able to merge information between two databases that house the same information. I have the scenario set up below.
A co-worker came to me for a database that they work with for Grants for the company. They normally use the original database file to make changes. A separate coworker added information into the _Backup database instead of the original database. Now there is information in both databases to where the number of records do not match in each database. On that same note, a certain student may be in both copies with a different amount of classroom hours. What is the best way to try to merge this information?