Create XSD from SQL Server Database

[ifmo114]

Any code tips on creating a single XSD file for a SQL Server database with many tables?

Thanks.

 

[RiverGuy]

Fill a DataSet, and call the DataSetName.WriteXMLSchema() method.

 

[ifmo114]

Thanks, but how do I fill a DataSet with an entire database (over 50 tables) so I get one xsd for the entire DB? Do I just write one big sql statement that joins every table in the DB?

 

[RiverGuy]

Well, you can select and drag multiple tables at a time from the server explorer to the Database Designer. So there's that. Or you can always generate your code from T-SQL itself. For example, running this query in Management Studio to generate some VB.Net code.

SELECT 'MyCommand.CommandText = "SELECT * FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']"' + CHAR(13) + CHAR(10) +
'MyDataAdapter.FillSchema(MyDataSet, SchemaType.Mapped)'
FROM INFORMATION_SCHEMA.TABLES