Changeset 9492 for branches/HivePerformance

Timestamp:

05/14/13 12:44:18 (11 years ago)

Author:

pfleck

Message:

#2030
Added filestream access level configuration in SQL scripts.

Location:

branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts

Files:

• Initialize Hive Database.sql (modified) (1 diff)
• Migrate to Filestream.sql (modified) (3 diffs)

branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

@@ -1 +1 @@
 USE [HeuristicLab.Hive-3.3]
 /* create and initialize hive database tables */
+
+EXEC sp_configure filestream_access_level, 2
+GO
+RECONFIGURE
+GO 
 
 SET ARITHABORT ON

branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Migrate to Filestream.sql

@@ -1 +1 @@
 USE [HeuristicLab.Hive-3.3]
 
+EXEC sp_configure filestream_access_level, 2
+GO
+RECONFIGURE
+GO 
 
 /**********************************************************/
@@ -12 +16 @@
   CONSTRAINT [PK_dbo.TaskDataTemp] PRIMARY KEY ([TaskId])
 )
-  
+
 INSERT INTO dbo.TaskDataTemp (TaskId, Data, LastUpdate)
 SELECT TaskId, Data, LastUpdate
@@ -50 +54 @@
   CONSTRAINT [PK_dbo.PluginDataTemp] PRIMARY KEY ([PluginDataId])
 )
-  
+
 INSERT INTO dbo.PluginDataTemp (PluginDataId, PluginId, Data, [FileName])
 SELECT PluginDataId, PluginId, Data, [FileName]