By using the management agent for Microsoft SQL Server, you can synchronize with Microsoft SQL Server 7.0 or SQL Server 2000.
The following Microsoft Identity Integration Server 2003 versions support this management agent:
This is a call-based management agent.
The schema is generated based on the source database table definition. When you refresh the schema for this management agent, the connected data source schema is rediscovered, the current management agent schema is updated, and then Management Agent Designer starts. In Management Agent Designer, you can correct any inconsistencies introduced by the updated schema, such as deleted object types or deleted attributes.
Configuring management agents
Create a management agent
Connect to a Microsoft SQL Server database
Configure connector filter rules
Configure join and projection rules
Configure attribute flow rules
Configure deprovisioning rules
Configure password management and specify rules extensions