Knowledgebase
Handy Software Lab > Handy Software Lab Help Desk > Knowledgebase
Share |

How do I use FileStreams store printed documents images in file system instead SQL database

Solution

This feature is supported in MS SQL Server 2008 any edition, read more at:

http://www.microsoft.com/sqlserver/2008/

If you are using SQL Server 2005 or 2005 Express you should upgrade it to MS SQL Server 2008.

The HSLAB Print Logger creates the  named SQL Server instance - PRINTLOGGER. You should upgrade only this instance of the SQL Server 2005/2005 Express.

How to upgrade:
 

  • Stop the "HSLAB Print Logger" service from the "Computer Management" or from the command line (NET STOP "HSLAB Print Logger").
  • Enable FILESTREAM according this description: "How to enable FILESTREAM in Microsoft SQL Server 2008", then execute this query:

USE PRINTLOGGER
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE
GO
ALTER DATABASE PRINTLOGGER ADD FILEGROUP PRINTLOGGER_FS_GROUP CONTAINS FILESTREAM
GO
ALTER DATABASE PRINTLOGGER ADD FILE ( NAME = 'PRINTLOGGER_FS_GROUP', FILENAME = 'c:\ProgramData\Handy Software Lab\HSLAB Print Logger\Data\Snapshots' ) TO FILEGROUP PRINTLOGGER_FS_GROUP
GO
ALTER TABLE PrintedDocuments ADD SnapshotStreamID uniqueidentifier ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWSEQUENTIALID()
GO
ALTER TABLE PrintedDocuments ADD SnapshotFileStream varbinary(max) filestream
GO

 
Was this article helpful? yes / no
Article details
Article ID: 186
Category: HSLAB Print Logger
Date added: 2011-06-04 15:25:16
Views: 175
Rating (Votes): Article rated 3.0/5.0 (2)

 
<< Go back

© 2012 Handy Software Lab. All Rights Reserved.