XML into SQL Server 2000
July 7, 2008 Sql Server, Xml — Tags: Sql Server, sql server2000, Xml, xml into sql server — 52coding
聽XML聽 into聽 SQL Server a number of ways, here one of three kinds:
聽聽 1. COM interface loading capacity. If you need to document the entities and attributes into to the table, the fastest way is to use SQL Server 2000 Extensible Markup Language 3.0 Service Pack 1 (SQLXML 3.0 SP1) provides high-capacity load COM interfaces. Large state COM interfaces included in the SQLXML 3.0 SP1 in the free download.
聽
聽聽 2.textcopy.exe command-line utility. If you do not want the document to extract entities and attributes to the table, you can use textcopy.exe command-line utility. Textcopy.exe is the type of text and image data from a single server row or column moved into or out of the excellent tools.
聽
聽聽 3. Data conversion services (DTS). If the XML document is very simple, you can use DTS to extract information line by line to the table. This approach will require you to enter the XML file is defined as the data source, database tables will be defined as the output data source, and the preparation of ActiveX script analysis “<” and “>” character input method to extract entities, attributes and their values.
