Import XML files to SQL Server 2000

Source: Internet
Author: User
Q: How can I import an XML file to SQL Server 2000?
A: There are several ways to import XML files to SQL Server. Here, we provide three of them:
Large-capacity load COM interface. To extract the object and attribute of a document to a relational table, the fastest way is to use the large-capacity loading COM interface provided by SQL Server 2000 Extensible Markup Language 3.0 Service Pack 1 (SQLXML 3.0 SP1. The large-capacity status COM interface is included in the free download of SQLXML 3.0 SP1.
Textcopy.exe command line utility. You can use textcopy.exe command line utility if you do not want to extract the contents and tokens of the document to the relationship table. Textcopy.exe is an excellent tool for moving text and image data types from a single server row or column to or from.
Data conversion service (DTS ). If the XML document is simple, you can use DTS to extract information to the table row by row. This method requires that you define an XML file as an input data source, define a database table as an output data source, and write an ActiveX script to parse character input in the "<" and ">" mode, to extract entities, attributes, and values.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.