Joined: 29 Oct 2012
|Posted: Mon Oct 29, 2012 6:32 am Post subject: Creating a filestream database using Sql packager 6
I'm trying to restore a filestream enable database and get the following error:
Default FILESTREAM filegroup is not available in database 'TestDB'
I used sql packager to create a C# project. the original database was filestream enabled and had a table with a filstream data column.
the inner exception shows the create table script:
CREATE TABLE [dbo].[FileStreamDataStorage]
[ID] [int] NOT NULL IDENTITY(1, 1),
[FileStreamData] [varbinary] (max) FILESTREAM NULL,
[FileStreamDataGUID] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF__FileStrea__FileS__014935CB] DEFAULT (newsequentialid()),
[DateTime] [datetime] NULL CONSTRAINT [DF__FileStrea__DateT__023D5A04] DEFAULT (getdate())
CONSTRAINT [UQ__FileStre__FB6FAD9C7F60ED59] UNIQUE NONCLUSTERED ([FileStreamDataGUID])
I think the problem is the new databse is not filestream enabled and when it tries to create a table with filestream column it is erroring.
can anyone please help?