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.
| Author |
Topic |
|
Galius_Persnickety
Starting Member
10 Posts |
 Posted - 2009-02-23 : 20:22:35
|
| I've manually created small XML schemas to map the contents of an XML file into SQL table(s), but it's an arduous and error-prone process when done by hand.What are people who have lots of large, complex XML documents to import into SQL doing to create these maps?Gabe |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 09:19:12
|
| are you asking about importing large xml files to sql table? |
 |
|
|
Galius_Persnickety
Starting Member
10 Posts |
Posted - 2009-02-24 : 10:51:06
|
| Yes, but there are 5-6 different formats I need initially, more to come. So a single schema map won't do, I'll need to be creating a bunch of them for different kinds of XML source files.I'm using the SQLXMLBulkLoad component, which has worked flawlessly in my tests.Gabe |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 12:30:12
|
| what determines your schema? |
|
|
|
Galius_Persnickety
Starting Member
10 Posts |
Posted - 2009-02-24 : 14:04:06
|
| The XML document format is determined by outside organizations (the gov't & their contractors), whereas I'm free to format my database however I like.Gabe |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-25 : 09:10:54
|
| then whats makes it necessary to create multiple schemas? wont a generalised one will do? |
|
|
|
Galius_Persnickety
Starting Member
10 Posts |
Posted - 2009-02-25 : 15:50:18
|
| I suppose it might...But then I'm constantly editing one large schema to add new xml formats to. Seems like the scaleability problem persists.Gabe |
|
|
|
|
|
|
Mapping XML file to SQL Tables