This is probably a stretch ...
... but does SS05 provide ability to describe the DDL for a table in XML
One step further would enable table creation purely based on that XML doc.
Of course, I could write custom code to do this, based on my XML design.
But perhaps there is some built-in ability ...
SS05 : create table from XML ?
Hot Topic
- ambiguity performance problem
- Locking of rows of MS SQL Server 2005 database table in disconnected environment
- Custom connection manager doesn't show up in VS?
- View can not sort?
- current users
- Warning after installing SQL Management Studio SEPT CTP
- MSSQL 2005/Native Client problem with IColumnsInfo->GetColumnInfo()
- Error grouping in Pivot table with OLEDB for Analysis Servises 9.0
- How To Update data?
- Reset Excel Destination for Error Logging
SQL Server
- Unable to use Reporting Services
- Which Raid for SQL 2005
- Multivalue Parameter SQL Server 2005 SP1
- Database Mail does not work from SQL Agent Job
- Replication of structure
- Start SSIS Package from VB
- Str() not locale aware
- Work tables/bookmark lookups
- Cannot build SQL Server Mobile solution for Windows Mobile 5
- Install SQL 2005 Express error (ParseBootstrapOptionsAction)
SS05 : create table from XML ?
Lattwell
1. Use the XML template files and just put the DDL into a sql:query element. Yes, I know that this is cheesy and not what you probably were expecting as an answer, but the question is why you would want to use XML instead of the DDL in the first place.
2. If you have an annotated XML Schema, you can use the SchemaGen property of the SQLXML Bulkload object to get a first cut at generating a table. Note that it is however somewhat limited in supporting complex SQL schemas.
Since I have the feeling that neither are completely addressing what you want, could you please explain your scenario in a bit more detail Why would you want to do it