0

SQLXMLBulkLoad requires schemas to be annotated with various attributes (e.g. sql:datatype) and some additional elements. Is there any tool that can enrich a schema with this information for at least some basic scenarios?

skaffman
  • 398,947
  • 96
  • 818
  • 769
Frank de Groot - Schouten
  • 182
  • 1
  • 11

1 Answers1

0

I have asked a similar question and have done some researches. It seems that there is not tool to create SQLXMLBulkLoad schema in the market. I am trying to write one by myself. Since the schema is a XML file, we can use LINQ to XML to insert the annotation information.

Don
  • 1,532
  • 4
  • 24
  • 47
  • Well I started writing something myself too but I haven't gotten much further. Are you going to put something on CodePlex/GitHub/...? I can do that if you're interested but I never got past the first few unit tests. – Frank de Groot - Schouten Dec 03 '10 at 20:44
  • 1
    @Frank de Groot - Schouten, I decide not to use SQLXMLBulkLoad any more for my project. Instead I will used SQLBULKCOPY which is about 10 times faster for my dataset. – Don Dec 04 '10 at 01:43