Open Dental Forum

We're currently in the midst of syncing the data from multiple Open Dental installs into a single multi-tenant database.

1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)?

2) Is there an identifier or a label (e.g. SiteID, Install_Id) that uniquely identifies an install?

Thanks in advance!
-Tyler

tholmes wrote:1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)?

The way to uniquely identify a database is by the registration key. You can use this query: SELECT * FROM preference WHERE PrefName = 'RegistrationKey';

2) Is there an identifier or a label (e.g. SiteID, Install_Id) that uniquely identifies an install?

Could you elaborate on what you mean by this question?

Hey Chris,

Thanks for the reply. The second question is looking for a more "human readable" version of the first answer.

Is there anything besides a RegistrationKey that describes an install?

Are there any Non-unique traits of an OD install that help identify a Site/Practice (e.g. Joe's Dental, Smile Dental Practice #182)? I'm ok with human entered/generated descriptive text that I can use to pair with less meaningful identifiers.

Nearly every preference in FormPractice should help to identify a database somewhat uniquely. If you are fine with human entered info then that would be the best choice.