Where is Textcopy.exe? 2

[mrgulic]

I have installed every single component for SQL Server 2008 R2 Developer Edition except for Reporting and Analysis Services and textcopy.exe is nowhere to be found.

Everything I have read says it should be under

C:\Program Files\Microsoft SQL Server\100\Tools\Bin\

or

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

I have search the entire structure under

C:\Program Files\Microsoft SQL Server\

and found nothing.
I want to try my hand at full-text indexing of pdf files in sql server 2008.
I see that many have issues with it but it seems that there are limited options for searching numerous PDF files quickly and returning those results to a user via asp.net.

Any help would be much appreciated.

 

[gmmastros]

I encourage you to take a look at this:

http://sequelserver.blogspot.com/2007/01/texcopy-sql-server-2005.html

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLBill]

When we were upgrading our SS2000 servers to SS2008, that is one thing we found no longer exists. You will have to come up with an alternate solution and George's link is the best place to start.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[mrgulic]

Thanks, I found a solution when I found out that Textcopy was obsolete.


[ol]
[li]Install Adobe IFilter (verify that it is installed)

SELECT * FROM sys.fulltext_document_types

[/li]
[li]Crate table. you can call the columns whatever you like.

CREATE TABLE [dbo].[Blob](
  [BlobFileId] [int] IDENTITY(1,1) NOT NULL,
  [BlobFileName] [varchar](50) NULL,
  [BlobFileType] [varchar](100) NULL,
  [BlobFileBinary] [varbinary](max) NULL
  ) ON [PRIMARY]

[/li]
[li]Import file into table:

Insert Blob(BlobFileName, BlobFileType, BlobFileBinary) 
Select 'somePDFfile.pdf','PDF file', BulkColumn from Openrowset( Bulk 'C:\somePDFfile.pdf', Single_Blob) as tb

[/li]
[li]Create Index on blob table[/li]
[li]Search Indev:

SELECT [BlobFileId],[BlobFileName],[BlobFileType],[BlobFileBinary] FROM [Blob]
WHERE freetext([BlobFileBinary], 'search text value here')

[/li]
[/ol]
and that's how i made mine work it.