Updating the default database on the current host

To update data from XML feeds in an SQL Server database running on the same machine as Exult, use the command shown below. Note the following points:

• SQL Server is running on the same machine as Exult
• Uses SQL Server Authentication to log into the database.
• The database used is the default database for the user under whose account Exult is running.
• The command Exultcmd.exe should be located under C:\Program Files\Novixys Software\Exult SQL Server 1.1 or wherever Exult has been installed on your machine.

Exultcmd.exe -U -a

Updating a specified SQL Server database on another host

Use the following command to update all XML files loaded into SQL Server when you need to specify the hostname and/or the database name.

To update the a specified database on a specified SQL Server host:

Exultcmd.exe -U -a sql.server.com@databaseName

The following command shows how to specify the SQL Server instance along with the server name and the database name.

Exultcmd.exe -U -a sql.server.com\instanceName@databaseName

The databaseName can be skipped if it is the default database for the user running the command:

Exultcmd.exe -U -a sql.server.com@

Or the server can be skipped if SQL Server is running on the same host as Exult

Exultcmd.exe -U -a @databaseName

Updating SQL Server using a username and password

Use the following command to update XML files loaded into SQL Server when using SQL Server Authentication.

Exultcmd.exe -u username -p password -U -a sql.server.com@databaseName

Selecting the XML files to be updated

To update a specified XML file (or URL), just skip the -a option and list out the XML file location as shown below:

Exultcmd.exe -U sql.server.com@databaseName http://www.example.com/path/to/File.xml

You can update multiple XML file locations in one go:

Exultcmd.exe -U sql.server.com@databaseName http://www.example.com/fileA.xml http://www.example.com/fileB.xml

Update from a remote XML file or a local XML file:

Exultcmd.exe -U sql.server.com@databaseName c:\Path\to\FileA.xml http://www.example.com/fileA.xml