This topic will show you how to merge databases step by step. We have a company with three locations and we have two of the locations where we copied the TimeClockWindow database to a removable drive so we can merge the data to the computer in the main office. First we select Merge Databases under the Database tab in the administrator program like seen below.
Then we click on the small button as seen below to open the File Open Dialog.
You would then locate the removable drive with the databases to merge with the main database. I want to point out that the main company database's file name is "Alpha Gardening Center" and as you can see below, we added " - 1" and " - 2" to the filename used in the other locations so we know which database we are working with. We start with the fist by selecting it and click the Open button.
That returns you to the Merge window and you should then click the Merge button.
Then you will see the time transactions that need to be merged. Merging right and left will update both databases. In this example we are clicking the Merge Right button.
Then as you can see below, both databases are now in sync. However if you want to keep all three databases synced, you would perform the operation again on this one. You will repeat the process with the third database to complete the merge.
This next screen shows that if you select the Merge Employees Tab, you can also merge the employee changes. But in this case both are already in sync.
And the same goes for merging departments as seen below.
