Importing Large XML Documents using TEXTCOPY.EXE

By Bill Graziano on 3 December 2003 | Tags: XML


Jay submitted "I came across this article while looking at options for importing large XML Files into a SQL Server Text field.

It is an undocumented command line utility called TEXTCOPY.EXE.

If you don't want to extract an XML document's entities and attributes into relational tables during an insert, you can use the textcopy.exe command-line utility. Textcopy.exe is a good tool for moving text and image data types to or from a single server column and row.

Once in the DB you can manipulate it as needed.

It has been briefly mentioned by Rob Volk in Some posts:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6014&whichpage=1

and it has proved to be a useful commandline tool for our need."

Link: Importing Large XML Documents using TEXTCOPY.EXE


Related Articles

Parsing XML from a text column using sp_xml_preparedocument (5 December 2003)

XML Validator (9 February 2003)

SQLXML 3.0 SP1 (21 November 2002)

SQLXML 3.0 SP1 (10 June 2002)

Microsoft SQL Server 2000 Web Services Toolkit (19 February 2002)

SQLXML 3.0 Beta available for download (31 December 2001)

XML dominates database file formats (with Yukon info) (26 November 2001)

SQLXML 2.0 (XML for SQL Server 2000) (12 November 2001)

Other Recent Forum Posts

Need help with nested list in SQL (5h)

Can't restore bak file from MS SQL Server 2000 (2d)

Connecting to SQL Server from externally with proxy server (2d)

How to Find if Java is Installed (2d)

How To Insert Title At Start of SQL Results and Between Another SQL Result Sets (2d)

Help with sql query find combinations that are not equal, please (3d)

Transpose Query Help (3d)

Excel blobs and BCP extract commands (5d)

- Advertisement -