Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Simmetrics fuzzy matching

Author  Topic 

silver_surfer21
Starting Member

21 Posts

Posted - 2011-03-14 : 12:37:11
Hi, can anyone tell me whether its still possible to get SimMetrics running for SQL Server and if so how to go about it? As I've tried following the only page I can find on the matter

http://anastasiosyal.com/archive/2009/01/11/18.aspx

and its 'step by step' guide doesn't have enough steps. It just says compile the jar and create a dll. I've tried running the jar in Eclipse but haven't been able to create a .dll file which it says is required for the next step.

Any ideas?

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2011-03-14 : 13:45:41
you don't use the jar. you have to build a .net dll, which you can do with the c# port. that port is here:

http://sourceforge.net/projects/simmetrics/files/simmetrics.NET%20and%20amp_%20phonetics.NET/SimMetrics%20v1.5%20.NET%20update/


elsasoft.org
Go to Top of Page

silver_surfer21
Starting Member

21 Posts

Posted - 2011-03-16 : 10:03:17
ok I've downloaded that and opened it in Visual C# but have no idea what to do with it, having never used it before. :(
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2011-03-17 : 08:46:03
you need to build the dll. did you build the SimMetrics.dll?

That's step 2 in the step-by-step process here: http://anastasiosyal.com/archive/2009/01/11/18.aspx in this section "3. Adding string Metric functions in MS Sql Server"

After you build it, continue with the rest of the steps.

EDIT: actually it looks like you can skip some of the steps if you download this: http://anastasiosyal.com/code/TextFunctions.zip - it has the SimMetrics.dll built in it already, and has SQL scripts to import the dll and create the CLR functions giving you access to the apis.



elsasoft.org
Go to Top of Page

silver_surfer21
Starting Member

21 Posts

Posted - 2011-03-17 : 09:07:19
thanks, the reason I was having trouble is because my version of Visual Studio was too new for the download, but I've got it going now :)
Go to Top of Page

sadsa
Starting Member

1 Post

Posted - 2011-11-21 : 08:02:30
Hello. Becouse the site is down, can you please upload TextFunctions.zip to another page?



Go to Top of Page

dom_usa
Starting Member

2 Posts

Posted - 2012-07-24 : 12:36:03
Hi everyboy
Go to Top of Page

dom_usa
Starting Member

2 Posts

Posted - 2012-07-24 : 12:37:23
Hi everyboy,

with which MS Visual Studio Version does the code from the website mentioned above work? I tried 2010 and 2008 but did not succeed.

thx
Go to Top of Page

fguiccia
Starting Member

3 Posts

Posted - 2012-12-13 : 11:35:31
Working fine for me! you guys rock!
Questions: Anybody had use the CompareStringMetrics function or child functions to group duplicates using big data sets?
Any performance issues? I am going to start that exercise in a few minutes.

Best regards,

Ferruccio Guicciardi
BI Consultant
Go to Top of Page
   

- Advertisement -