I would say its more dependent on the OS than the database. There are a lot of good free tools out there for PDF's, images, etc. on Linux. Most of the windows server stuff I've seen, you need a license for.
There is also two ways to look a the whole scene of document management too. 1) Do you want to store actual images (ala PDF's, tiffs, etc.)? 2) Do you want to store the data that the documents contain and use that data to "reprint" or populate a from when you need it? The 2nd way is more flexible and easier to search through because its database driven. The 1st way is more annoying in my opinion, and usually gets used when a company has to have, the actual image of the document itself (for legal reasons or whatever). I would say SQL, etc. is no different than U2 when it comes to document management. Its all the tools around the database that is going to help get the job done for you. Use the database you know best :) On Fri, Jul 22, 2011 at 11:16 AM, George Gallen <ggal...@wyanokegroup.com>wrote: > I would store the pdf's in separate location (on or off the server) under a > unique > UV assigned filename. > > Then in the U2 database, store the original name, unique name, pathname and > any other > information. > > I'd use off server storage in case your disk space runs out, you won't > chance > crashing your U2 server. > > You can always connect your server to that location either via SMB / NFS / > mapped drive > so it can still appear to U2 as a local file if you need to get the actual > pdf data. > > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > > Sent: Friday, July 22, 2011 11:10 AM > > To: U2 Users List > > Subject: [U2] Document Management > > > > Does it make any sense to use a U2 database to save scanned pdf's? > > That is... > > > > Does it make any sense to save small blobs in a U2 data base? > > > > Would a Type 1 file be best? > > > > Are there any advantages to using MS-SQL, MySQL, or some other database > > technology? > > > > --Bill > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
