Deploying MDS SQL 2008 R2 Features Without MDS

Question

SQL Server 2008 R2 has a new feature called Master Data that includes some really nice features of regular expression and extraction:

http://msdn.microsoft.com/en-us/library/ee633712.aspx

I am running 2008 R2 and want to run these functions outside the MDS database.

How can I? Is there a way to extract them and reapply them to my own db?

Answer 1

I realized this and fully registered it (with screenshots) on my blog. http://www.pettijohn.com/2010/08/regular-expressions-in-sql-2008-r2.html

In short:

• MDS D:\MasterDataServices\x64\1033_ENU
• MDS. .
• Script Microsoft.MasterDataServices.DataQuality(// / Script as/Create)
• AUTHORIZATION db_datareader
• ( ) , script, .
• USE dbo .
• , .

Answer 2

, .

Sql Server 2008 R2 MDS

:

TVFs:

• NGrams
• RegexMatches
• RegexSplit
• Split

SVFs:

• RegexExtract
• RegexIsMatch
• RegexIsValid
• RegexMask
• RegexReplace
• SimilarityDate
• XmlTransform

dbo.

Answer 3

You can access .NET Regex classes through CLR integration in SQL 2005/2008. See: Regular expressions make it easy to match patterns and delete data.