Updating Info from one Open Dental DB to another...

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
Davo
Posts: 7
Joined: Thu Nov 01, 2007 3:14 pm

Updating Info from one Open Dental DB to another...

Post by Davo » Fri Jan 04, 2008 2:30 pm

Good Afternoon,

My office is planning to do some off site exams in the future. We are trying to prepare a plan for merging the data with the existing database at the main practice. We plan to use a laptop with an individual copy of Open Dental on it, then when we return to the office we want to be able to update only the records that we changed while we were on the road. Is there a process or query you know of to accomplish this?

Thanks,
David

User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Post by Jorgebon » Fri Jan 04, 2008 2:41 pm

If you are not going to make any changes to the database in your office while you are out doing the exams, it would be easy to just use the backup and restore features of Open Dental. On the other hand, if both databases are going to have changes at the same time, there's no way I know of that you could merge them both into one without messing things up. Maybe Jordan can help you with this.

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks » Sat Jan 05, 2008 6:50 am

You could use circular daisy chain replication.
http://www.open-dent.com/manual/daisych ... ation.html
Jordan Sparks, DMD
http://www.opendental.com

User avatar
Justin Shafer
Posts: 596
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Cool

Post by Justin Shafer » Sun Jan 06, 2008 3:10 pm

I will look into this.. Havent heard of daisy chain replication before.... So what are the limitations if replication stops? Can you still enter data? I guess that would work ok...

Does the database or Open Dental recognize multi locations??? Or say is it like Op1-Op5 would be locaton1... Op6-Op10 could be location2...

Havent used multilocation software yet... Except for QBPOS MultiStore.. :twisted:

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks » Sun Jan 06, 2008 5:27 pm

We have a Clinic feature with good support for this situation. http://www.open-dent.com/manual/clinics.html
Jordan Sparks, DMD
http://www.opendental.com

Post Reply