In my work we're now generating a database from a lot of XSD (50-100) for generating reports. This is a constriction imposed by the ministery, so there's nothing we can do. So the problem I'm having is that doing them by hand with no errors is almost imposible, lots of missing foreing keys and isolated tables, so I'm looking for a software that can receive the whole batch of XSD and generates the whole structure of the database. I have checkeed XSD2DB, which can't connect to my, and Altova's XMLSpy, which is expensive and doesn't solve my issue because I forced to load each XSD separately and without keys relating to other tables.
The best case scenario requirements would be:
- Generate a DB structure given a batch of XSD
- Connect to MySQL
- Open source > Free > Paid
- Be python-friendly
- Be able to graphically see the generated DB structure and manipulate it
The important one is the first one, please and thank you!