How To Merge Databases

[jovivier]

It is generally a good idea, before you merge any databases, to make a copy of your working database. This is not necessary if you already have a backup copy of your database. You can make a copy of your database in several different ways. One way is by using Windows Explorer to create another copy on your computer or on a removable disk (e.g., CD, pendrive).

Merging the databases:
Open the IRRICAD Database editor. Note that in some cases you may need to move the database window down so that you can get access to the database menu. To do this place the cursor over the blue bar at the top of the window labeled “Irrigation Components - ….”. Click and drag the window down until the menu containing “File | View | Utilities | Help” appears.

The File|Merge option allows you to add one database to another. The merge function checks for matches before adding any items.
To merge a database:

1. Select File|Merge.
2. Select the database you wish to have items added from (in this instance it will be the manufacturer database - this database is opened but will remain as it is. To select left click on the top button on the right-hand side with three dots on it and follow the directory path until you locate the required database file.
3. Select the database you wish to add items to - this database will have items added. To select left click on the bottom button on the right-hand side with three dots on it and follow the directory path until you locate the required database file.
4. Click the Merge button.

A file is created (DBMergeReport.txt) in the Irricad folder directory. Check this file to see a report on the components that were merged. If there are any components in the new database that are already in your existing database, IRRICAD will list these as not merged in this text file. It also lists the items that are matched.

If you have any queries regarding this process or the database please contact either your distributor or AEI Software.