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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-04 : 11:40:23
|
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."Article Link. |
|
|
|
|
|
Article: Importing Large XML Documents using TEXTCOPY.EXE