I am sitting with lots of data in multiple xml files, which I would like to convert to relational data, for better being able to analyze it. Are there any tools that can transform the data / import to a database with a minimum of work?

In this specific case, the data will map very nicely to relational data, It is not completely flat, but the structure have a simple parent-child nesting. However there are no IDs, so keys and foreign keys will need to be generated.

I have been looking at Xpath queries, SQLXML Bulk load, SSIS and so on, and they seem to be too much work. Yes I know, I am being lazy, but knowing that the xml schema may change from time to time, I don't want to put too much work in it, I just want an easy way to summarize the data, without having to tinker with building a database schema manually, and then scripting queries to populate the DB.

Any tips or tools?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.