all groups > sql server data warehouse > september 2007 >
You're in the

sql server data warehouse

group:

storing documents


storing documents Pure Heart
9/24/2007 10:56:09 AM
sql server data warehouse: hi

can SQL Server 2005 enterprise of any other version store documents such as
word, acrobat, Excel
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Re: storing documents Joe
9/24/2007 1:46:07 PM
Yes - of course you can use it to store those types of files - BLOB's.

You should first to some research on the pro's and con's of going down this
path. Many will argue it's better to let the file system manage your
documents and just store the path on your network to these locations save in
a SQL table.

There are full blown document management systems out there if you're in a
position to purchase them also. If you do decide to store them as BLOB's in
your SQL table's; make sure you model your tables correctly in anticipation
of moving towards a full blown system.

[quoted text, click to view]
AddThis Social Bookmark Button