I have installed Microsoft SQL server 2012 enterprise edition. But under Start-> Microsoft SQL Server it is not showing option of Data Quality Services (DQS). I read in tutorial, to install DQS i need DQSinstaller.exe. But is is not available in my version.
My work -
I have to validate my database columns. e.g. There is name column and it contain integer. I have to detect such rows. I read in tutorial, DQS is providing such facility to validate data.
is DQS really solve my problem?
I need to check out, We dont have support in DQS here. Please help..
- Edited by Ashish Waykar Wednesday, January 08, 2014 1:01 PM
Must go thru given URL : this will help you for DQS http://blogs.msdn.com/b/dqs/archive/2011/07/17/installing-and-configuring-data-quality-services.aspx
If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Varinder Sandhu www.varindersandhu.in
1. DQS can do some data type checks with a rule, yes.
You can also do RegEx pattern matching for fancier logic in a DQS Rule.
I think you can do TSQL to do rudimentary pattern searching
For example to search for a number digit in a column
SELECT * FROM TABLE WHERE Col1 LIKE '%%'
2. Yes, you need to select the Data Quality Services and Data Quality Client at the time when the SQL SETUP is run to get the start menu icons.
If it is a cluster, you cannot add features afterwards. If it is a standalone (not clustered I mean) you can add features by running the SQL 2012 setup again from the Add/Remove programs.
DQS is only in Enterprise, BI, and Developer editions however. If unsure of your version you can query SELECT @@VERSION in the SQL Database Engine to see, or look in management studio at the server name properties in the Object Explorer pane while connected to SQL Database Engine.
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
- Proposed as answer by Jason H (Azure)Microsoft employee, Moderator Wednesday, January 29, 2014 5:30 AM