DQS in Standard Edition?

Question

Can anyone clarify what DQS features are available in SQL Server 2012 standard edition?

My understanding was that DQS was only available in the BI and Enterprise editions of SQL Server 2012 (http://www.microsoft.com/sqlserver/en/us/editions.aspx and http://technet.microsoft.com/en-us/library/cc645993), however I've just installed DQS with an instance of SQL Server Standard Edition - it was part of the features available to install.

I'm confused as to why this feature was available and whether there are any differences between the DQS feature-set in Standard Edition and the other editions of SQL Server?

Answer 1

My guess is that you can install DQS so that you can still use the client to connect to other SQL instances which are BI or Enterprise edition.
After the DQS installation you still have to configure it (run a script that creates databases and some other stuff in the SQL Server instance), and I think it will go wrong there.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 2

No, the installation scripts all ran fine.  It's created three DQS databases on my Standard Edition server instance.   It allows me to connect to the server, create Data Quality Projects etc.  I guess I'll have to give MS Licensing a call...

Answer 3

Odd. Maybe it's just the SSIS DQS component that only works on Enterprise.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

As per http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#Other_Components it's not in Standard.

However the cleansing component isn't called out as unsupported: http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#SSIS_AA

The short answer is if it does install & function it's probably an oversight and therefore don't consider it supported.

Cheers, James

---

James Beresford @ www.bimonkey.com & @BI_Monkey
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex