Usage Summary
Importing XML into SQL Server:
Exultcmd.exe [Options] DBString InputFile(s)
Update all XML Feeds in SQL Server:
Exultcmd.exe [Options] -U -a DBString
Database Cleanup:
Exultcmd.exe [Options] -U -a ConnectionStr
Options
-
-n: Dry-run option. Shows the input files that will be
processed and the output files that will be created without actually
doing anything.
-
-q: Turns on quiet mode which suppresses progress reporting.
Use this option when processing large files since progress reporting
slows down the program a little bit.
-
-u Username: Login to SQL Server with the specified
username. If this option is not used, Windows Authentication is used
for connecting to SQL Server.
-
-p Password: Password for connecting to SQL Server when using
SQL Server Authentication.
-
-U: Update Feed option. If data from any of the specified
input file/URL is found in the database, it is updated with the latest
data from the input file/url. The data is NOT updated if the contents
of the input file have not changed from the last time it was updated.
-
-U -a: Update All Feeds option. All documents loaded into the
database are checked for changes and reloaded. Useful as an automatic
feed engine (for auto-update of XML feeds). With this option, input
file/url arguments are not accepted.
-
-X: Cleanup the database.
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.