BulkXML.exe - Bulk load XML files in to SQL Servers

version: 1.0x05
last updated: 24 August 2004
platform: SQL Server 2000 running Windows NT 4.0 and higher

Description:

BulkXML is a command line wrapper around the XML bulk load interface SQLXMLBulkLoad, which was introduced in SQLXML.

Usage:

BulkXML.exe version 1.0x4

BulkXML usage:

-S SQL server name
-E Integrated security
-U User name
-P Password
-d Database

-i Data file
-s Schema file
-e Error log file
-p Temp file path

-B Bulk load off (default On)
-D Drop tables
-G Generate schema
-I Keep identity
-K Ignore duplicate keys
-N Keep NULLs
-T Force table lock
-X Check constraints
-t Transaction
-u Use ID
-x XML fragment

-V Verbose mode
-v Version information
-? Command line usage

Sample usage:

BulkXML.exe -S (local)\dev -E -d testdb -i c:\temp\xml\SampleXMLData.xml -s c:\temp\xml\SampleSchema.xml -e c:\te
mp\xml\sample.log -p c:\temp -V

Output:

BulkXML usage:

-S = (local)\dev
-E = True
-U = (null)
-P = (null)
-d = testdb

-i = c:\temp\xml\SampleXMLData.xml (exists True)
-s = c:\temp\xml\SampleSchema.xml (exists True)
-e = c:\temp\xml\sample.log
-p = c:\temp (exists True)

-B = True (BulkLoad)
-D = False (SGDropTables)
-G = False (SchemaGen)
-I = False (KeepIdentity)
-K = False (IgnoreDuplicateKeys)
-N = False (KeepNulls)
-T = False (ForceTableLock)
-X = False (CheckConstraints)
-t = False (Transaction)
-u = False (SGUseID)
-x = False (XMLFragment)

Installation:

Simply copy BulkXML.exe onto your machine, make sure that SQLXML 3.0 SP2 is installed!

Download BulkXML.zip

Download BulkXML-src.zip (Visual Studio 2003 - C++ project)

Requirements:

MDAC 2.6 or later must be installed before the installation can be run.
SQLXML 3.0 SP2 or later

Planned functionality enhancements:

None
Other suggestions, ideas, please send email to ideas

***