The goal is to create related tables in MS SQL , the structure of which is taken from shops.dtd (or based on its basis shops.xsd ).

How to do it automatically (unless, of course, there is such an opportunity at all)?

    1 answer 1

    In order to automatically create tables from the schema, the schema must be properly prepared.

    In this case, you will be able to automatically create the tables and fill them with data from the XML file corresponding to the schema.

    The tool for such operations is called SQLXMLBulkLoad — you can easily find the tool itself and instructions for using it, here’s one example:

    https://blogs.msdn.microsoft.com/monicafrintu/2007/06/12/how-to-create-tables-in-a-database-using-an-xsd-schema-and-sqlxmlbulkload/