SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Simmetrics fuzzy matching		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

silver_surfer21
Starting Member

21 Posts
Posted - 03/14/2011 :  12:37:11  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2871 Posts
Posted - 03/14/2011 :  13:45:41  Show Profile  Visit jezemine's Homepage  Reply with Quote
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 - 03/16/2011 :  10:03:17  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2871 Posts
Posted - 03/17/2011 :  08:46:03  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Edited by - jezemine on 03/17/2011 08:51:50
Go to Top of Page

silver_surfer21
Starting Member

21 Posts
Posted - 03/17/2011 :  09:07:19  Show Profile  Reply with Quote
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 Posts
Posted - 11/21/2011 :  08:02:30  Show Profile  Reply with Quote
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 - 07/24/2012 :  12:36:03  Show Profile  Reply with Quote
Hi everyboy
Go to Top of Page

dom_usa
Starting Member

2 Posts
Posted - 07/24/2012 :  12:37:23  Show Profile  Reply with Quote
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

Ireland
3 Posts
Posted - 12/13/2012 :  11:35:31  Show Profile  Reply with Quote
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
Edited by - fguiccia on 12/13/2012 11:36:05
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000