Converting XML data dump to MySQL DB

[Dave Hanna]

Forgive me if this is a naive message or treated elsewhere. I have a
broad undersanding of XML concepts, but am pretty shallow when it
comes to details.

I have an XML data dump of a products database. I would like to create
a relational database from it (e.g., in MySQL, MS SQL Server 2000 or
2005, or even Access, I don't much care.)

Is this a trivial task, or moderate? (I can conceive how to do it in a
program, so I know it can't be enormously difficult) Are there ready
made tools available (at low or no cost) to do this, or do I need to
write a program? I have Visual Studio 2005 available (with the MySQL Connector), and am
proficient in VB and C#. I know that with a few lines of code, I can
create an XML reader and use it to infer the XML Schema. Is there an
easy way to use that to generate the SQL Data Definition statements
(CREATE TABLE, etc.) to create the database tables?

The data appears to have about half a dozen tables in it that would
have to be linked by foreign keys. If there are no ready made tools
to do this, is there an easy way to read through the XML records and
write the data out to the SQL tables and properly link all the
entries?

And if this is not the right group, please feel free to point me to
the most appropriate one.

Thanks in advance for your assistance.