3. Using the command line to import XML into SQL Server

Exult for SQL Server includes a command line which allows you to perform the following tasks in a batch mode environment:

  • Shred and import data from one or more XML files into SQL Server.
  • Import XML from HTTP and FTP URLs
  • Perform database cleanup to undo all changes made by Exult to SQL Server. This is useful if you want to reload data from XML sources.
  • Update data for one or more imported XML files in the database.

The command line interface to Exult is called Exultcmd.exe and should be installed in the same location as Exult.exe itself, typically:

C:\Program Files\Novixys Software\Exult SQL Server 1.2\Exultcmd.exe

Check out the following sections for more details on how to accomplish each task from the command line.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.