The following examples describe how to import XML into SQL Server from the command line.
For the syntax of DBString, click here.
To use SQL Server Authentication, specify a user name and password for connecting to SQL Server.
Exultcmd.exe DBString C:\Path\To\File.xml
Data from the XML files are merged according to the XPath and imported into SQL Server.
Exultcmd.exe DBString C:\Path\To\File_1.xml C:\Path\To\File_2.xml
Exultcmd.exe DBString C:\Path\To\*.xml
Exultcmd.exe DBString C:\Path_1\To\*.xml C:\Path_2\To\*.xml ..
Exultcmd.exe DBString http://www.example.com/Path/To/File.xml
Exultcmd.exe DBString
http://user@passwd:www.example.com/Path/To/File.xml
Exultcmd.exe DBString ftp://ftp.example.com/Path/To/File.xml
Exultcmd.exe DBString
ftp://user@passwd:ftp.example.com/Path/To/File.xml
Exultcmd.exe DBString http://www.example.com:8080/Path/To/File.xml
Exultcmd.exe DBString ftp://ftp.example.com:2121/Path/To/File.xml
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.