We have a Medical software (lets call it Software A) which uses SQL database in the background. We want all of this data imported in another Medical software (lets call it Software B). Software B also uses a sql based db.
My client wants to stop using Software A and needs to have his data migrated to Software B.
1. The software's are from different company so the data tables/structure is different.
2. As these are commercial software - we cant approach Software A or B to reveal their database structure.
1. Both Software A & B as part of design allow export of data as XML. There could be a way to map xml files so what is exported out of A can be imported into B?
2. We also have access to the full sql db of Software A with data in it. If a tool can be written to import data out of that sql db into Software B?
We are open to suggestion and happy to work with the developer to get this solution.