I've got a table in a mssql database that stores attachemnts of varying filetypes (.pdf, .doc, .ppt, .msg). I need to extract all of these files out of the database and into a folder on my hard drive. I'm running SQL Server 2008 Enterprise Edition.
I was looking to avoid writing code, but I dont' seem to be having much luck finding an app that will do this for me. Anyone know of an app that work, or have a coding solution?
Here's the makup of the table:
CREATE TABLE [dbo].[FileSystem](
[AttachmentID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[FileData] [image] NULL,
[DataTypeColumn] [varchar](4) NULL,
CONSTRAINT [PK_FileSystem] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]