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