I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
Also the database where this table is created should provide similar functionality as a file server open, edit, check in, and check out on stored files. Can I do this in SQL Server 2000?You can store documents in the text or image data type.
You probably can't search on them, but your could store a summary in a character-based field with the record, or a column that just contains keywords.
Yes, you can provide functionality similar to a file-server...you just have to write it all yourself. :(
I can tell you that you are looking at a daunting project here that will likely involve complex coding. The user-interface will probably also prove difficult.
Perhaps somebody else on the forum will see this post and could recommend some professionally designed 3rd party software for document management?
blindman
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment