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.

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.

Shred and import XML into SQL Server.

Import XML data into automatically created MySQL tables.

Import XML into Oracle.

3.1 How to import XML into SQL Server from the command line
3.2 Using the Windows Scheduler to schedule XML Import into SQL Server
3.3 Command line reference