Data Quality Server and Data Quality Client belonged to SQL Server’s historical DQS feature set, enabling knowledge-driven data profiling, cleansing and review.
Concepts and context
The server held the knowledge bases and related project data. The client offered workflows for discovering values, maintaining domain rules, running cleansing projects, and reviewing uncertain corrections.
Practical application
For an existing supported legacy installation, verify the exact SQL Server version, permissions, feature state, system prerequisites, backups and documented installation order. For new workflows, use constraints, profiling, validation rules and review queues.
Compatibility and cautions
DQS is removed in SQL Server 2025 and remains associated with older supported releases. Always test schema and cleanup procedures on copied data before applying them to business records.
AI and reuse disclosure: This newly written tutorial was generated with AI using an existing Open Education article (post 22427) as its starting point; explanations and examples may have been added. You may copy, edit and reuse the generated text with or without a reference. Rights in trademarks and third-party content remain with their respective owners. AI can make mistakes. Verify version compatibility, code and operational advice against current official documentation.
