Filegroup Error

atoth

Hi
I am packaging up a database (not for upgrading, just a straight create database).

I have one user defined Filegroup ('CVDATA') for a table with an image field.

I have unchecked the ignore filegroups option, but when I run the package exe I get "Invalid Filegroup 'CVDATA' specified duoring the database creation.

Have I misssed something?

Thanks
Adam

Brian Donahue

Hello Adam,

Sorry, SQL Packager cannot create filegroups. It does, however, create the script for the object including the filegroup, ie CREATE TABLE x ... ON CVDATA.

This leaves you two options: One is to set the schema option 'Ignore Filegroups', which means that the table will be created on PRIMARY, and the other is to create a filegroup first on the database by 'other means', for instance a VBScript that you can run before running the package.

atoth

Thanks. I have had a closer look inside the c# package that you create and I think I understand now!