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
Identifier for Open Dental Installation
Re: Identifier for Open Dental Installation
The way to uniquely identify a database is by the registration key. You can use this query: SELECT * FROM preference WHERE PrefName = 'RegistrationKey';tholmes wrote:1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)?
Could you elaborate on what you mean by this question?2) Is there an identifier or a label (e.g. SiteID, Install_Id) that uniquely identifies an install?
Re: Identifier for Open Dental Installation
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.
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.
Re: Identifier for Open Dental Installation
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.