Monday, May 28, 2012 11:40 AM
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?
- Edited by Danny Shisler Monday, May 28, 2012 11:41 AM
Wednesday, May 30, 2012 12:00 PMMy 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.
Friday, June 01, 2012 9:40 PM
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...
Saturday, June 02, 2012 8:01 PM
Thursday, June 14, 2012 12:33 AM
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.
- Proposed As Answer by Koen VerbeeckMicrosoft Community Contributor Thursday, June 14, 2012 5:57 AM