3.1 How to import XML into SQL Server from the command line
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.
-
Import a single XML file into SQL Server
Exultcmd.exe DBString C:\Path\To\File.xml -
Import multiple XML files into SQL Server
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 -
Import a bunch of XML files
Exultcmd.exe DBString C:\Path\To\*.xml -
Import a bunch of XML files in different directories
Exultcmd.exe DBString C:\Path_1\To\*.xml C:\Path_2\To\*.xml .. -
Import data from a HTTP URL
Exultcmd.exe DBString http://www.example.com/Path/To/File.xml -
Specify username and password for use with HTTP
Authentication
Exultcmd.exe DBString http://user@passwd:www.example.com/Path/To/File.xml -
Import data from an FTP URL using Anonymous FTP
Exultcmd.exe DBString ftp://ftp.example.com/Path/To/File.xml -
Specify user name and password for retrieving a file with FTP
Exultcmd.exe DBString ftp://user@passwd:ftp.example.com/Path/To/File.xml -
Specify a different port number in a HTTP URL
Exultcmd.exe DBString http://www.example.com:8080/Path/To/File.xml -
Specify a different port number in a FTP URL
Exultcmd.exe DBString ftp://ftp.example.com:2121/Path/To/File.xml