Table of Contents
1. Import XML into SQL Server
1.1 Import a single XML file into SQL Server
1.2 Import multiple XML files into SQL Server
1.3 Import XML from an HTTP URL into SQL Server
1.4 Update (synchronize) XML feed in SQL Server
2. Using Exult for SQL Server
2.1 The Welcome Screen
2.2 The Trial Information Screen
2.3 The Registration Screen
2.4 The Database Connection Screen
2.5 XML File Selection Screen
2.5.1 Adding XML File URLs
2.5.1.1 Selecting URL type
2.5.1.2 Adding a HTTP URL
2.5.1.3 Adding an FTP URL
2.5.1.4 URL Download Progress Screen
2.5.2 Updating XML Feeds
2.6 XML Import Progress Screen
2.6.1 XML Import Completed Dialog
2.7 The Data Preview Screen
2.8 The Finish Screen
3. Using the command line to import XML into SQL Server
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.2.1 Adding a task to the Windows Scheduler
3.2.2 The Scheduled Tasks Wizard
3.2.3 Select Exultcmd.exe for scheduling
3.2.4 Specify time and frequency of execution
3.2.5 Specify user name and password
3.2.6 Scheduled Task Created
3.2.7 Advanced Task Settings
3.2.8 Advanced Scheduling
3.2.9 Advanced Settings
3.3 Command line reference
3.3.1 Specify the Database Connection String for importing XML into SQL
3.3.2 Specify the user name and password for connecting to SQL Server
3.3.3 Specify input XML files (or URLs) on the command line
3.3.3.1 Specifying URLs
3.3.4 Perform a dry-run (no execution) for sanity check
3.3.5 Turn on quiet mode to speed up execution in command line mode
3.3.6 Update data for one or more imported XML files (or URLs)
3.3.7 Update data for all import XML files (or URLs)
3.3.8 Perform database cleanup
4. Database Cleanup Wizard
5. Uninstalling Exult for SQL Server