There is only one way to import large amounts of data into a standard database (i.e. MySQL, PostgreSQL, etc.):
- process the data to create CSV files that your database can understand
- use the
LOAD DATA LOCAL INFILE ... command (or equivalent) to load those files into the database
If your data comes as XML (:o), you have to process that data using an XML library like
lxml in Python, and create CSV files that contain all the information that you need. "XSD to SQL" converters don't work with complex schema that most XML files contain, and XML databases (e.g. BaseX, eXist) are immature and have limits on the size of the files that you can import.
The same applies to SDF files.
modified 4.5 years ago
4.5 years ago by
ostrokach • 290