Question
CTS
AU
Last activity: 9 Feb 2017 21:29 EST
How to Store BLOB file attachment using FILESTREAM Storage in MS SQL Server?
Because of growing work attachment table, we want to use MS SQL Server's FILESTREAM Storage to move BLOBs to file system to reduce growing database size.
Would it be possible for Pega BLOB work attachments?
Did anybody use this approach? Any ideas? Please share with us?
Accepted Solution
Pegasystems Inc.
US
As of 7.2.2, we don't support filestream type. This MSSQL type requires database level, filegroup setup, etc.
As of 7.2.2, we don't support filestream type. This MSSQL type requires database level, filegroup setup, etc. MSSQL "FILESTREAM require a column of data type uniqueidentifier to identify each row in a table" besides the filestream varbinary(max) column
CTS
AU
Thank you. As an alternative we use SSIS job to move set of attachments to CIFS location and it can be accessed via Pega using OOTB features based to captured Metadata.