Caution: This is an advanced capability of NFS. Mistakes can cause the system to malfunction.
1. To set a bucket to be used for a specific customer within a NFS instance, modify the SET statement(s) in the following SQL query, then execute it against the database for the NFS instance
DECLARE @CustomerName VARCHAR(50)
DECLARE @BucketName VARCHAR(100)
SET @CustomerName = 'Test Customer QA'
SET @BucketName = 'MyCustomer'
BEGIN TRANSACTION
INSERT INTO CustomerVariable( CustomerId, Name, Value )
SELECT c.Id, 'BinaryBucket', @BucketName
FROM Customer c
WHERE c.Name = @CustomerName
COMMIT TRANSACTION
a. @CustomerName: the name of the customer you want to create a bucket for
b. @BucketName: must match the bucket name as defined in Step 2a of HOWTO: Add a bucket.
2. Perform an IISRESET on the machine where NFS is installed.
Related Articles:
Saving attachments outside the database
HowTo: Add a bucket to your NFS Server
HowTo: Set the bucket for the NFS instance
HowTo: Set the bucket for a specific customer (This Article)
Comments