Question

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?

https://msdn.microsoft.com/en-us/library/gg471497.aspx

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
December 8, 2016 - 6:37pm

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 
 

Comments

Keep up to date on this post and subscribe to comments

Pega
December 8, 2016 - 6:37pm

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 
 

February 9, 2017 - 9:29pm

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.