Bulk inserting XML into SQL Server
Postponed meetings today… but I didn’t care. My little Python library to run SQL Server’s XML storage is growing.
An hour ago I hacked up another small Python class: it takes XML data + a mapping Schema, creates tables and bulk inserts XML into SQL Server. It’s fast and very simple - and the necessary SQL XML Schema annotations can be ignored by any other applications.
So far I have written mapping schemas by hand - but there is a GUI called SQL Server XML View Mapper that might be useful. I’m wondering why it uses Semantic Modeling Format instead of simple SQL scripts, however. The docs say this is an unpublished format used by several MS products and then starts talking about BizTalk… but maybe I’m just paranoid.