Converting to Open Dental from MOGO
Posted: Thu Nov 03, 2011 6:43 am
Hello,
I am a database management intern working for a dental practice and I have been given the task to help set up new practice management software. The practice is currently using MOGO. At this point we are leaning strongly towards switching to Open Dental. My main question is about how to migrate the data from MOGO to Open Dental. Is it going to be a situation where I have to manually re-enter all the data to Open Dental?
I've been looking at the MySQL migration toolkit to convert the MS-SQL from MOGO to MySQL, but I realize that in doing that, I will still have to manipulate the data before I can put into OD. I was thinking of writing queries to convert try and put the data from the old database into the correct tables in the new database. Is this viable?
Will MOGO even allow me access to its tables? I have been setting up a test run to migrate a MOGO demo database to MySQL but have run into several snags along the way. If anyone has any experience in data migration I would love to get some advice.
I am a database management intern working for a dental practice and I have been given the task to help set up new practice management software. The practice is currently using MOGO. At this point we are leaning strongly towards switching to Open Dental. My main question is about how to migrate the data from MOGO to Open Dental. Is it going to be a situation where I have to manually re-enter all the data to Open Dental?
I've been looking at the MySQL migration toolkit to convert the MS-SQL from MOGO to MySQL, but I realize that in doing that, I will still have to manipulate the data before I can put into OD. I was thinking of writing queries to convert try and put the data from the old database into the correct tables in the new database. Is this viable?
Will MOGO even allow me access to its tables? I have been setting up a test run to migrate a MOGO demo database to MySQL but have run into several snags along the way. If anyone has any experience in data migration I would love to get some advice.