Is it relevant to write an xml parser?

Question

Programming

Dear developers, what do you think about such a task - there is an xsd scheme and, accordingly, an xml file (the size of xml is not limited by anything). It is necessary to create a program that, based on this scheme, creates a database, for example, in ms sql and fills this database with data from an xml file. The xsd and xml files themselves are not known in advance (as well as their size). The first step is to use DataSet, but due to the file size (for example, 3GB), there is not enough memory and, accordingly, this option is no longer available. I would like to hear your opinion on the feasibility of this task, or is it essentially a "Sisyphean" work?

Answer 1

due to the file size (for example, 3GB), there is not enough memory and, accordingly, this option is no longer available.

Use a SAX parser .

Answer 2

If a database from this file is really needed, it is advisable to write. If it is possible to do without a DB - it is inexpedient. There is no point in writing the XML parser itself, there are a lot of ready-made implementations.

Answer 3

If you are talking about economic feasibility, but you can simply compare the cost of a programmer's labor against "buy 64 gigabytes of RAM / rent a server with more memory."