Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Creating Tables from an XSD file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-13 : 06:33:03
Joe writes "Can I automatically create tables in SQL based on the contents of an XSD File given to me.
I do not have a corresponding XML file with data just the XSD.
I was thinking maybe with XMBLBULKLOAD but it seems to want an XML data file.

Thanks in advace
Joe"

Kristen
Test

22859 Posts

Posted - 2006-09-13 : 08:12:09
The SQLXMLBulkLoad COM object has a method for creating the tables, not sure if it needs XML or XSD though ... XSD with a simple "<root></root>" XML file might be enough!

Kristen
Go to Top of Page
   

- Advertisement -