Sunday, February 19, 2012

Data type for storing MS Word documents/large data type?

Hi all,
I am bginning to build a SQL Server database that will be used to store
documents from various users. The document types will mostly be MS Word and
MS PowerPoint. I want to know what datatype to use in the database to store
these kinds of documents.
The data will be fed to SQL Server via an ASP.Net-based website. I would
also like to know if I can just use standard ASP.Net database objects to
transfer these large amounts of data.
Many thanks for any advice or a point in the right direction.
JustinHave you done any research on the pros and cons of storing the documents in
the database, vs. using a file system? It is going to be much more
efficient to store the *paths* to the files in the database. Have a read:
http://www.aspfaq.com/2149
"Justin Little" <JustinLittle@.discussions.microsoft.com> wrote in message
news:E4D7888D-C902-4B9F-AE6A-7A8FB2F6C921@.microsoft.com...
> Hi all,
> I am bginning to build a SQL Server database that will be used to store
> documents from various users. The document types will mostly be MS Word
> and
> MS PowerPoint. I want to know what datatype to use in the database to
> store
> these kinds of documents.
> The data will be fed to SQL Server via an ASP.Net-based website. I would
> also like to know if I can just use standard ASP.Net database objects to
> transfer these large amounts of data.
> Many thanks for any advice or a point in the right direction.
> Justin
>

No comments:

Post a Comment