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

Posted on 2012-08-16
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 39

    Accepted Solution

    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

    Sorry for the long delay!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now