Share via


Building Workflow Applications for SQL Server

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The Workflow Designer for SQL Server included with Microsoft® Office XP Developer makes it possible for you to build workflow-organizing applications based on a Microsoft® SQL Server™ database and a Web site user interface. The easiest method for developing the application is to create a workflow process using Workflow Designer for SQL Server and a user interface using Microsoft® Access, which makes it possible for you to incorporate the Office Developer Workflow Toolbar control into your data access pages. Using Access, it is easy to design and manage the SQL Server database schema and to create data access pages for the Web site user interface.

In This Section

Understanding the Workflow Application

The typical development life cycle involves planning, developing, testing, and distribution. While the workflow application follows this basic cycle, it provides flexibility in the development phase.

Developing Workflow Applications for SQL Server

Simplify the task of creating typical workflow applications, such as forms routing/approval, document review/publishing, and issue tracking, by using the workflow engine and specialized workflow modeling tools of the Workflow Designer of SQL Server.

Workflow Applications Architecture for SQL Server

Understand how the Workflow Designer for SQL Server and Workflow Services for SQL Server help you build, modify, and add script to workflow applications on a database.