Tim
Reputation: 89
create tables from xml schema (using C# & mssql)
Im looking for ways to create data tables in mssql using a XML Schema file to specify the relationships/datatypes (for c#?).
Currently I know I can use the SQLXMLBulkLoadLib.
Also right now I am exploring the dataset.writexmlschema/dataset.readxmlschema, but I don't know very much on how this works for nested elements
Are there any other methods?
Upvotes: 0
Views: 1392
Answers (1)
Alexander
Reputation: 4173
Probably you can import xml schema into DataSet, and then recreate database structure using SQL Server Management Objects. There is an article on codeproject containing some samples on how to do this.
Upvotes: 1
Related Questions
- How can I create database tables from XSD files?
- How to create SQL Server table schema from a XML schema? (with .NET and Visual Studio 2008)
- Creating SQL table from XML using C#
- Create XSD for defined XML and Table
- Create XML from Database Dataset and Generated XSD Class C#
- Generate SQL schema from XSD and load XML files into SQL Server
- Create xml with DataSet tables
- How to Generate an XML/XSD from a SQL Server Table?
- Tools to help me generate an xml schema for a mssql database?
- Writing an XSD Schema to put XML data into SQL tables