Exporting Workflow 10.x data to a SQL or other database
Back to
Exporting Workflow data
- Exporting Workflow data
- Auto export to SharePoint Lists
- Explicit Export to SharePoint Lists
- Explicit Export to a Database
- Manually Exporting Process Data
Related Topics
This approach is similar to the method described under exporting to SharePoint lists but differs in the destination for the data. With this approach, you can specify a database and have your workflow, and optionally SharePoint data, exported to this database.
The database has a predefined schema that must be used (see the Schema.sql file included with this script), but you can also add more database fields to contain additional data from the SharePoint lists.
To explicitly export workflow data to a database:
- Create a database using this script (.ZIP file).
Note: The script is for SQL Server. It can easily be modified for other databases.
- At a command prompt on your server, run the following command:
svadm -o updateprocessstatuslist -url <URL to the root site to export> -config <path to your database configuration file> -recurse - At a command prompt on your server, run the following command:
svadm -o updateassignmentstatuslist -url <URL to the root site to export> -config <path to your database configuration file> -recurse
The configuration file includes your database connection string and any field maps that describe the name of a SharePoint field and the corresponding name of the database field to which to copy the SharePoint data.