Joining multiple databases (concatenating databases)

<< Click to Display Table of Contents >>

Navigation:  Administration > Database Administration > Concatenating Databases >

Joining multiple databases (concatenating databases)

Administrators on the Concordance Desktop server can concatenate databases using either Concatenate Database function in the Databases task pane, selecting the Concatenate option from the File menu, or by dragging and dropping a DCB, DAT or PST onto an existing database. Please note that only those who are assigned as administrators on the Concordance Desktop server where the concatenation needs to be performed, have the ability to concatenate databases.

When reviewing a concatenated dataset, all tags in all databases display in the Tags panel. If you apply a tag from one database to a record in another database, Concordance Desktop automatically writes that tag into the record’s corresponding database.

Databases that have been converted from Concordance 10.x cannot be concatenated with new databases created in Concordance Desktop. In addition, you cannot drag and drop a migrated database onto a new database created in Concordance Desktop, or vice versus.

To Concatenate Databases

You can only concatenate databases if you are a Concordance Desktop Administrator on the server where the databases reside.

1.Do one of the following:

On the File menu, click Administration, then Concatenate, and then Edit concatenation.

Drag and drop a DCB, DAT, or PST file onto an existing database

i.The Concatenated Databases dialog box opens.

ii.If the database you have open is already the primary database in a concatenated file set, the list displays all the database files in the set.

iii.If the database you have open is not in a concatenated file set, this list shows only that database.

2.Click the Add button.

3.Locate and Select the database file you want to join with your current database.

i.The file path is added to the Concatenated Databases box.

The Current Database panel in the Databases task pane displays all the concatenated databases, the total number of documents in the concatenated set, and whether the databases need reindexing.

Joined databases in a Concatenated database set only remain concatenated for the current session unless you save the concatenated database set. Once you close out of the database, the concatenation is removed from each of the databases in the set.

To remove the database concatenation, on the File menu, click Administration, then Concatenate, and then Clear Concatenation. You can only use this method if you are a Concordance Desktop Administrator on the server where the databases reside.

The Table view layout corresponds to the active database you are reviewing. If you view a record from a concatenated database, your Table view layout changes to display the fields and sort order for that database. Remember to reference the Concordance Desktop Title bar to see what database you are viewing for a particular record.

If you are reviewing multiple joined databases at a time, it may be helpful to change the font color or size in each database to help you differentiate between the databases at a glance.