Hi everyone,
I searched, but didn't find anything on this. I'm in the process of switching to Dentrix Plantinum sensors for digital x-ray and am wondering if anyone is running Dentrix with MySQL Server instead of the default Microsoft SQL Server (on Microsoft Windows) on the backend. I'd like to stay away from Windows if at all possible. (My Open Dental server is Linux-based, with MySQL Server and a Samba fileserver.)
I haven't dug into the configuration specs yet to see if it can be done - has anyone had success?
Thanks!
Brad
Dentrix server/backend
Dentrix server/backend
________________________
Brad Johnson, D.D.S.
Corridor Family Dentistry, PLLC
2120 Westdale DR SW
Cedar Rapids, IA 52404
(319)396-7263
Brad Johnson, D.D.S.
Corridor Family Dentistry, PLLC
2120 Westdale DR SW
Cedar Rapids, IA 52404
(319)396-7263
Re: Dentrix server/backend
I don't have specific experience but can speak as a seasoned database admin: It MAY work but I'd advise against it. If you do choose that path I'd advise heavy testing, and don't update the version before heavy testing of the new versions in case new queries have been introduced.
MySQL can not be a drop in replacement for MSSQL the same way MariaDB can be used in place of MySQL. While MSSQL and MySQL both speak the same SQL language if you will, they do so with differing dialects. If the Dentrix system makes use of statements that are not compatible with MySQL, for example the FULL JOIN, then the program will behave unpredictably.
MySQL can not be a drop in replacement for MSSQL the same way MariaDB can be used in place of MySQL. While MSSQL and MySQL both speak the same SQL language if you will, they do so with differing dialects. If the Dentrix system makes use of statements that are not compatible with MySQL, for example the FULL JOIN, then the program will behave unpredictably.
There are 10 types of people in this world, those who will laugh at this joke, and those who won't. ~Annonymous Bug Writer
-
- Posts: 5
- Joined: Wed May 04, 2016 10:39 am
- Location: Kansas City, MO
- Contact:
Re: Dentrix server/backend
I would have to call Dentrix to find out for sure to find out about MySQL support. But in the event they say they do not support MySQL, you may just wait a little bit. Microsoft announced they SQL Server on Linux is coming soon: http://blogs.microsoft.com/blog/2016/03 ... -on-linux/
John Moses
https://www.sendthereminder.com
Automated patient communication system: reminders, overdues, confirmations, newsletters
https://www.sendthereminder.com
Automated patient communication system: reminders, overdues, confirmations, newsletters
- Justin Shafer
- Posts: 596
- Joined: Sat Jul 28, 2007 7:34 pm
- Location: Fort Worth, TX.
Re: Dentrix server/backend
I think you mean Dexis right? Dexis and Open Dental bridge nicely.
Justin Shafer
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com