Is there a way to make SQL schemas and relationships from an XML file automatically?

Posted on 2012-08-16
Medium Priority
Last Modified: 2012-10-11
We have been supplied and XML file and need to turn it into a MS SQL database. It's very complex so we're hoping to find a tool that can also build the relationships between the tables.
Does anyone know of a standalone tool or a visual studio plug-in?
Question by:juliandormon
LVL 40

Accepted Solution

lcohan earned 2000 total points
ID: 38301636
As far as I know ERWIN data modeling tool can do that however...why not ask whomever sent the XML doc to generate a SQL Script with ALL objects in that DB instead of sending the XML doc?

Author Closing Comment

ID: 38487888
Sorry for the long delay!

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question