Creating a filestream database using Sql packager 6

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Creating a filestream database using Sql packager 6

Postby learner Prog » Mon Oct 29, 2012 6:32 am

Hi,
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?
learner Prog
 
Posts: 1
Joined: Mon Oct 29, 2012 6:15 am

Postby Manfred.Castro » Tue Oct 30, 2012 5:16 pm

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using SQL Server Configuration Manager.
http://msdn.microsoft.com/en-us/library/cc645923
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 1 guest