Using SQL Server to store large text files 
Author Message
 Using SQL Server to store large text files

Hello,

I am trying to use SQL Server to store text files in order to make each
searchable. Initially I wanted use the contains operation to do fuzzy
string matching to allow for wildcard searches. The problem I am having
is I can make a text field in a table but how do I store the entire
text file which is like 82k into this database field.

I am using ADO, and a table with a text field which I understand will
handle data greater than 82k. I read something about Micorsoft Indexing
service which will allow me to query the files directly from the drive.
This seems like a better solution but how do I set this up?

Please mail any suggestions to the address on this post.

Thank you..


Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 22 Jun 2002 03:00:00 GMT
 Using SQL Server to store large text files

Use the TEXT type and then enable the FULL-TEXT Search engine that comes with
SQL 7.  Full details in the books-online

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (400 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk



Sun, 23 Jun 2002 03:00:00 GMT
 Using SQL Server to store large text files
You need to examine the maintenance aspects first of all of storing
huge text files in sql server; this is not what it was made for.  Yes
you can do it but like a lot of these things, I question the wisdom.
You are much better off storing directory listings and filenames of
these text files, and then using a front end VB application to
parse/search/do pattern matching.  You are really asking for trouble on
this one.  I get the feeling you are trying to do some kind of document
management thing and this is NOT the way to do it.

Sent via Deja.com http://www.deja.com/
Before you buy.



Sun, 23 Jun 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Using SQL Server to store large text files

2. Using SQL Server to store large text files

3. Writing Large Text field to a text File in Stored Procedure

4. Need help storing large text and images into SQL Server 6.5

5. Ned help storing large text and images into SQL Server 6.5

6. Need help storing large text and images into SQL Server 6.5

7. Storing Large Text Docs in SQL Server

8. Help - Storing large text fields within SQL Server????

9. Trying to fetch large text/memofields from SQL server 6.5 using ASP fails

10. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)


 
Powered by phpBB® Forum Software