October 27, 2004 at 1:27 pm
Hi,
I have a requirement to save either Word documents or .RTF documents (that are can be converted into Word documents or opened in word "as-is") into SQL server 2000. This system requires that the documents are archived in SQL server with additional audit information and can be retrieved at will.
Obviously, RTF is just text but given its "bulk", it might be better saving a compressed version in some kind of Zip type format. I suppose in this case, the same kind of binary storing would occur as would with a regular .DOC file.
So, the question breaks down into saving voluminous text (eg., the plain RTF document) or binary in the form of the .DOC/Zip data. Are there any "best practices" in this respect? (I am sure many people must have had this requirement before).
What data type(s) should be considered for Word documents and RTF files?
Any advice much appreciated.
October 27, 2004 at 1:49 pm
See, if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 28, 2004 at 7:58 pm
Also for performance reasons I suggest only storing the documents in a table (and only document data) and its related information in a separate table as a One-To-One relationship. Maybe a Primary Key, a Foreign Key and a Title if any.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply