Archived OD dbs causing a problem
Posted: Thu Oct 29, 2020 7:13 am
I have some third party software that imports HL7 messages into the db. It's written for SQL, but they support MySQL. I have run into an issue where their MySQL Schema Engine will get confused if there is more than one OD database in the MySQL data folder, which is where OD places archived dbs when the user does an update of OD. They tell me this is because of the way SQL works as opposed to MySQL. So I will need to watch that folder and move those archived dbs to another folder in the filesystem. I plan on creating a folder and notifying the user via a MessageBox that I have moved those backup dbs to that folder. Anything else I need to be aware of so that I don't create issues for OD support staff?