November 18, 2004 at 11:24 am
Has anyone used SQL Server 2000 as a searchable document repository? Additionally have you used it with a web interface which allows sending search criteria back to the database? Also, what about version control?
One last item, have you used or heard of plone.org?
Thx for any info you can provide.
CLM
November 19, 2004 at 4:12 am
Here's an explanation about SQL Server and binary data in general. It might give you some ideas:
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]
November 19, 2004 at 7:22 am
We have created a document storage application using ASP and SQL2K. Nothing overly robust, but it allows end-users to specify title, summary, some additional classification info, and one or more file attachments for each entry in the "DocStore". We use ASPUpload to get the file from the client to the server, then store the data in SQL, using IMAGE fields for the actual file data. We also store the content type so that displaying the document using its native app is pretty easy. The app also has a search capability -- basically I capture filter criteria on a web page and send it to an ASP page which in turn calls a stored proc to filter the results from the database. As of today the DocStore has about 1500 entries totalling about 6.5GB of data. This DB is on a server that also serves about 10 other databases, so it's not a dedicated machine (although it is a dedicated SQL Server machine, not co-installed with IIS).
On the same SQL Server I also have another database that is similar. Every month we get a 270+MB flat file from one of our data providers. This flat file contains about 1500 "groupings" of data records. What I do is compile an XML document of all the individual rows of data for each "grouping" and store this XML in SQL Server, this time using a TEXT field to store the XML. This DB serves a Visual Basic application installed on users' PCs. The app grabs an XML data record, applies an XSL transform, and presents the data to the user in a readable format. As of now there are 29000+ XML groupings totalling about 5.5GB.
November 19, 2004 at 7:37 am
Frank and Rookie you guys are awesome!
This is what I was looking for and I will definitely read the document you recommended Frank.
Thanks Again
CLM
November 25, 2004 at 2:10 pm
Document Locator is an affordable document management system that stores documents inside SQL Server.
Document Locator manages any kind of file you can save on a Windows-based file server, including Word, Excel, PowerPoint, PDF, AutoCAD, TIFF4 image files, multimedia files, and more. It is easy to use because it’s fully integrated into Windows Explorer, Microsoft Office applications, Outlook, AutoCAD and much more. Designed to replace the network file serve, Document Locator stores your documents inside Microsoft SQL Server to provide a robust scalable document management system. Document Locator supports current versions of Microsoft servers. The client installs and runs on Windows 2000 and XP systems.
Gain a new level of control and security over your documents: store and retrieve documents immediately, manage versions, manage linked documents, publish documents to the Web, automate scanning, manage email & faxes, manage projects and much more. We offer a family of solutions that are used successfully by small, medium and large businesses, enterprises, and government agencies.
http://www.documentlocator.com
Thanks
R Day
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply