File Storage to DB

Our company is planning to store the projects they have been creating for
years. The projects contain many different kinds of files (Adobe, Microsoft
Office e.t.c). The storage and the interface application should allow the
projects (Hundereds of Analysis documents also) to be reviewed, modified and
saved back in the same original format. Initial data will be around 1 TB and
expected to grow.
Is this something an SQL Server Database can handle ?. What would be the
good Software-Hardware suggestion ? Software to allow the above mentioned
modifications ?
Thanks for any input.I would take a serious look at SQL 2008 and the new FileStream datatype as
it sounds perfect for this type of application.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
> Our company is planning to store the projects they have been creating for
> years. The projects contain many different kinds of files (Adobe,
> Microsoft
> Office e.t.c). The storage and the interface application should allow the
> projects (Hundereds of Analysis documents also) to be reviewed, modified
> and
> saved back in the same original format. Initial data will be around 1 TB
> and
> expected to grow.
> Is this something an SQL Server Database can handle ?. What would be the
> good Software-Hardware suggestion ? Software to allow the above mentioned
> modifications ?
> Thanks for any input.
>|||Thanks Andrew for a quick response. FileStream datatype would help me to
stored the data but how about retrieve, modify and save ? Do I need a third
party application that will help me do this ? If so, any suggestions ?
What about hardware ? What will be an efficient setup this kind of work ?
Thanks again.
"Andrew J. Kelly" wrote:
> I would take a serious look at SQL 2008 and the new FileStream datatype as
> it sounds perfect for this type of application.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
> > Our company is planning to store the projects they have been creating for
> > years. The projects contain many different kinds of files (Adobe,
> > Microsoft
> > Office e.t.c). The storage and the interface application should allow the
> > projects (Hundereds of Analysis documents also) to be reviewed, modified
> > and
> > saved back in the same original format. Initial data will be around 1 TB
> > and
> > expected to grow.
> >
> > Is this something an SQL Server Database can handle ?. What would be the
> > good Software-Hardware suggestion ? Software to allow the above mentioned
> > modifications ?
> >
> > Thanks for any input.
> >
>|||"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:BEC98495-7594-43ED-BD3C-3102F4D61591@.microsoft.com...
> Thanks Andrew for a quick response. FileStream datatype would help me to
> stored the data but how about retrieve, modify and save ? Do I need a
> third
> party application that will help me do this ? If so, any suggestions ?
> What about hardware ? What will be an efficient setup this kind of work ?
>
> Thanks again.
>
If you aren't planning to develop your own application then take a look at
one of the Content Management System (CMS) offerings on the market. Choose a
complete solution rather than trying to choose a DBMS first.
--
David Portas|||As David stated SQL Server is only a database, it is not an application.
Many applications work with SQL Server but you can not use it as is for your
intended purpose.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:BEC98495-7594-43ED-BD3C-3102F4D61591@.microsoft.com...
> Thanks Andrew for a quick response. FileStream datatype would help me to
> stored the data but how about retrieve, modify and save ? Do I need a
> third
> party application that will help me do this ? If so, any suggestions ?
> What about hardware ? What will be an efficient setup this kind of work ?
>
> Thanks again.
>
> "Andrew J. Kelly" wrote:
>> I would take a serious look at SQL 2008 and the new FileStream datatype
>> as
>> it sounds perfect for this type of application.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "DXC" <DXC@.discussions.microsoft.com> wrote in message
>> news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
>> > Our company is planning to store the projects they have been creating
>> > for
>> > years. The projects contain many different kinds of files (Adobe,
>> > Microsoft
>> > Office e.t.c). The storage and the interface application should allow
>> > the
>> > projects (Hundereds of Analysis documents also) to be reviewed,
>> > modified
>> > and
>> > saved back in the same original format. Initial data will be around 1
>> > TB
>> > and
>> > expected to grow.
>> >
>> > Is this something an SQL Server Database can handle ?. What would be
>> > the
>> > good Software-Hardware suggestion ? Software to allow the above
>> > mentioned
>> > modifications ?
>> >
>> > Thanks for any input.
>> >
>>