Navigation:  Installation > Server > Virtuelles Dateisystem > FileStream aktivieren

DECLARE @SQL nvarchar(max)

SET @SQL = 'ALTER DATABASE [' + db_name() + '] ADD FILEGROUP [FileStream] CONTAINS FILESTREAM '

EXEC sp_executesql @SQL

 

GO

 

DECLARE @SQL nvarchar(max)

SET @SQL = 'ALTER DATABASE [' + db_name() + '] ADD FILE ( NAME = N''FileTable'', FILENAME = N''C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\FileTable'' ) TO FILEGROUP [FileStream]'

EXEC sp_executesql @SQL

 

GO

 

ALTER TABLE ft_Dokumente SET (FILESTREAM_ON = FileStream)

 

 

ALTER TABLE ft_Dokumente ADD [MigrateFileData] varbinary(max) FILESTREAM  NULL

UPDATE ft_Dokumente SET [MigrateFileData] = [FileData]

ALTER TABLE ft_Dokumente DROP COLUMN [FileData]

EXEC sp_rename 'MigrateFileData','FileData','COLUMN'