1 | USE [HeuristicLab.Hive-3.3]
|
---|
2 |
|
---|
3 |
|
---|
4 | /**********************************************************/
|
---|
5 |
|
---|
6 | /* Move old Task Data */
|
---|
7 |
|
---|
8 | CREATE TABLE [dbo].[TaskDataTemp](
|
---|
9 | [TaskId] UniqueIdentifier RowGuidCol NOT NULL,
|
---|
10 | [Data] VarBinary(MAX) Filestream NOT NULL,
|
---|
11 | [LastUpdate] DateTime NOT NULL,
|
---|
12 | CONSTRAINT [PK_dbo.TaskDataTemp] PRIMARY KEY ([TaskId])
|
---|
13 | )
|
---|
14 |
|
---|
15 | INSERT INTO dbo.TaskDataTemp (TaskId, Data, LastUpdate)
|
---|
16 | SELECT TaskId, Data, LastUpdate
|
---|
17 | FROM dbo.TaskData
|
---|
18 |
|
---|
19 | DELETE FROM dbo.TaskData
|
---|
20 |
|
---|
21 | /* Alter TaskId and Data Column */
|
---|
22 |
|
---|
23 | ALTER TABLE dbo.TaskData
|
---|
24 | ALTER COLUMN [TaskId] ADD RowGuidCol
|
---|
25 |
|
---|
26 | ALTER TABLE dbo.TaskData
|
---|
27 | DROP COLUMN Data
|
---|
28 |
|
---|
29 | ALTER TABLE dbo.TaskData
|
---|
30 | ADD [Data] VarBinary(MAX) Filestream NOT NULL
|
---|
31 |
|
---|
32 | /* Insert data */
|
---|
33 |
|
---|
34 | INSERT INTO dbo.TaskData (TaskId, Data, LastUpdate)
|
---|
35 | SELECT TaskId, Data, LastUpdate
|
---|
36 | FROM dbo.TaskDataTemp
|
---|
37 |
|
---|
38 | DROP TABLE dbo.TaskDataTemp
|
---|
39 |
|
---|
40 |
|
---|
41 | /**********************************************************/
|
---|
42 |
|
---|
43 | /* Move old Plugin Data */
|
---|
44 |
|
---|
45 | CREATE TABLE [dbo].[PluginDataTemp](
|
---|
46 | [PluginDataId] UniqueIdentifier RowGuidCol NOT NULL,
|
---|
47 | [PluginId] UniqueIdentifier NOT NULL,
|
---|
48 | [Data] VarBinary(MAX) FileStream NOT NULL,
|
---|
49 | [FileName] VarChar(MAX) NOT NULL,
|
---|
50 | CONSTRAINT [PK_dbo.PluginDataTemp] PRIMARY KEY ([PluginDataId])
|
---|
51 | )
|
---|
52 |
|
---|
53 | INSERT INTO dbo.PluginDataTemp (PluginDataId, PluginId, Data, [FileName])
|
---|
54 | SELECT PluginDataId, PluginId, Data, [FileName]
|
---|
55 | FROM dbo.PluginData
|
---|
56 |
|
---|
57 | DELETE FROM dbo.PluginData
|
---|
58 |
|
---|
59 | /* Alter Data Column */
|
---|
60 |
|
---|
61 | ALTER TABLE dbo.PluginData
|
---|
62 | DROP COLUMN Data
|
---|
63 |
|
---|
64 | ALTER TABLE dbo.PluginData
|
---|
65 | ADD [Data] VarBinary(MAX) Filestream NOT NULL
|
---|
66 |
|
---|
67 | /* Insert data */
|
---|
68 |
|
---|
69 | INSERT INTO dbo.PluginData (PluginDataId, PluginId, Data, [FileName])
|
---|
70 | SELECT PluginDataId, PluginId, Data, [FileName]
|
---|
71 | FROM dbo.PluginDataTemp
|
---|
72 |
|
---|
73 | DROP TABLE dbo.PluginDataTemp |
---|