Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best field type for scanned documents
Message
From
27/06/2011 19:31:24
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
27/06/2011 15:34:25
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01516324
Message ID:
01516402
Views:
52
>>>>>Hi,
>>>>>
>>>>>I'm working on a system where the user wants to scan documents and store them in a database. I'm guessing at this point that scanning will be to a TIF or JPG, but am wondering if they may be able to scan to a PDF. What would be the best field type to store these scans?
>>>>
>>>>You have a few options.
>>>>
>>>>1. Only store a path to the file in SQL Server (this is the same suggestion as using VFP tables)
>>>>
>>>>2. Use VARBINARY(max) field
>>>>
>>>>3. Use new (SQL Server 2008) FileStream option.
>>>
>>>Thanks. Which option would you recommend?
>>
>>It all depends on the requirements. The first option is the easiest to implement and it requires less storage in the database, but it adds burden on supporting / managing files in the file system.
>>
>>For SQL 2008 I'd recommend the option 3, although I personally haven't worked with it.
>
>OK, thanks, I'll do some reading up on the FileStream then.

Check this blog: http://blog.farreachinc.com/2011/06/07/storing-files-in-sql-server-using-wcf-ria-services-and-silverlight-part-1

There's some Silverlight/RIA Services stuff in there, but you should be able to pick out the stuff you need.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform