Home User Manual Discussion Forum Search

Conversions:  Merging Databases

A database merge is performed when the data from two (or more) databases needs to be consolidated into a single database, such as for accounting reasons or when a practice is bought out. Merges can be performed on multiple databases, including other software systems which can be converted to Open Dental.   See Conversions.

Fees:  $300 per merge. For example, if you are merging 2 databases, the charge would be $300, if you are merging 3 databases, the charge would be $600.  If you are merging 4 databases, the charge would be $900. In general, if you would like to merge 'n' databases, then the merge charge will be ($300)*(n-1).

How it Works: 

  • One database is marked as the "superior" database; the other(s) are marked as "inferior".
  • Sometimes there are values and settings that are ambiguous in both databases.  In these cases, the "superior" database values are chosen over the equivalent values in the "inferior" database.  Examples:  practice address, the default provider for the practice, county names and codes.  More important information, such as patient accounts or charting, are never ambiguous, so the resulting database merge will contain all critical data from each database.

OpenDentImages folders: All scanned documents and images are stored in the OpenDentImages folder (A to Z folders). If there are multiple OpenDentImages folders (e.g. all locations already use Open Dental), the conversion team will require access to all OpenDentImages folders for all databases to be merged, at the time of the merge. We recommend storing the files on a thumbdrive, saving to an external directory, etc.

Patient Numbers and Digital Imaging Software: During the merge, patients in the 'inferior' database will receive new patient numbers to avoid duplication. If the digital imaging software you currently use uses patient number to open the patient's x-rays, you will need to renumber the patients in the imaging software. We can provide a spreadsheet of all patients and their patient numbers in the merged database.

See Merge Checklist.pdf

After two or more databases are merged and the resulting database has been in use, it is NOT possible to reverse the merge and change the live database back to the original databases. In effect, database merges are permanent.

 

Open Dental Software 1-503-363-5432