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.

1. Import a single XML file into SQL Server

   Exultcmd.exe DBString C:\Path\To\File.xml

2. 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

3. Import a bunch of XML files

   Exultcmd.exe DBString C:\Path\To\*.xml

4. Import a bunch of XML files in different directories

   Exultcmd.exe DBString C:\Path_1\To\*.xml C:\Path_2\To\*.xml ..

5. Import data from a HTTP URL

   Exultcmd.exe DBString http://www.example.com/Path/To/File.xml

6. Specify username and password for use with HTTP Authentication

   Exultcmd.exe DBString http://user@passwd:www.example.com/Path/To/File.xml

7. Import data from an FTP URL using Anonymous FTP

   Exultcmd.exe DBString ftp://ftp.example.com/Path/To/File.xml

8. Specify user name and password for retrieving a file with FTP

   Exultcmd.exe DBString ftp://user@passwd:ftp.example.com/Path/To/File.xml

9. Specify a different port number in a HTTP URL

   Exultcmd.exe DBString http://www.example.com:8080/Path/To/File.xml

10. Specify a different port number in a FTP URL

    Exultcmd.exe DBString ftp://ftp.example.com:2121/Path/To/File.xml