Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssunny
Posting Yak Master
133 Posts |
 Posted - 2008-11-10 : 14:42:20
|
| Hi Guys,Currently we have images in our database which is painful to manage. But now we decided to move images out of the database to a file system and only store the image path in DB.So my question is what is the best approach to move images from DB to a file system? Is this something can be done via sql script or DTS package?Any help would be greatly appreciated. Thanks. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-11-10 : 15:45:23
|
| SQL Server 2008 has new features to allow you to do this while still managing the files through the database engine. You might want to look into that.CODO ERGO SUM |
 |
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2008-11-10 : 16:48:24
|
quote:
Originally posted by Michael Valentine Jones
SQL Server 2008 has new features to allow you to do this while still managing the files through the database engine. You might want to look into that.CODO ERGO SUM
Thanks for the reply Michael.But I'm using sql 2000. |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2008-11-11 : 08:21:38
|
| Can somebody help me please? |
|
|
|
|
|
|
moving images to a file system