none
Need Installation and Technical guideline

    Question

  • Hi,

        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..

    Thanking You,

    Ashish Waykar

    ashish.waykar5@gmail.com

       


    Wednesday, January 08, 2014 1:00 PM

All replies

  • Hi Ashish,

    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

    Friday, January 17, 2014 7:29 AM
  • 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 '%[0123456789]%'

    http://technet.microsoft.com/en-us/library/ms179859.aspx

    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.

    http://technet.microsoft.com/en-us/library/gg492277.aspx

    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.

    Thanks, Jason


    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

    Wednesday, January 29, 2014 5:30 AM
    Moderator