Filegroup Error

atothatoth Posts: 10
edited February 24, 2006 1:59PM in SQL Packager Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • Thanks. I have had a closer look inside the c# package that you create and I think I understand now!
Sign In or Register to comment.