.net - Import documents into sql server -


i have application searches word documents (.doc , .docx) stored on file server. i'm trying import these documents mssql server can take advantage of full text search functionality there.

i have table contains information local hearings. each local hearing has record stored .doc or .docx file on file server, location of file stored column in table.

i'd either store document in column in original table, or set table documents in , fk original table. best solution? then, how structure it? save document varbinary(max)? i've seen articles store document image file, not how go doing it.


Comments

Popular posts from this blog

service - Android MediaPlayer calls onCompletion before it already finished -

javascript - Training Neural Network to play flappy bird with genetic algorithm - Why can't it learn? -

javascript - Create a stacked percentage column -