XML database import into MySQL with XSD Schema

wallsfd949

Golden Member
Apr 14, 2003
1,002
0
0
I must admit I have no clue on how the ? I'm supposed to get this to work.

I have a large .xml file that is a dump from M$SQL and a .xsd "schema" to go along with it. I have no clue how to get this into my MySQL database.

I have been STFW for the past 2 hours and nothing even remotely jumps out at me. I downloaded SQLyog and Navicat earlier today and farted around with them for about 3 hours with no success.

I wish I could say I trouble shooted this problem, but I have no where to start. Can anyone give me a breadcrumb in the right direction - google has not been my friend. I'm going to appologize for this post before someone jumps my case, I usually would like to have more information on what I've already tried, but I'm at a loss here. :(

 

joinT

Lifer
Jan 19, 2001
11,172
0
0
try downloading Enterprise Architect from http://www.sparxsystems.com.au/
you should be able to import the .xsd file..
then if you right-click on the table, you can generate SQL to create that table.. install phpMyAdmin and use that to execute the SQL..
you might even be able to connect directly to your mySQL database from EA and create it that way.. haven't played around with it enough to know for sure..