Options

Using custom filegroups

JonasGJonasG Posts: 11 Bronze 1
in DLM Automation
We run a database CI project in Jenkins, with DLM Autmation plugin. One database has custom filegroups, and can't be created. The databases is stored in Subversion.
What to do?
Use a pre-create script? Like in forum query FileGroup support? (Where to save/handle that script?)
Use a post-alter script? (Where to save/handle that script?)



· Share on Twitter

Comments

  • Options
    JoakimBackmanJoakimBackman Posts: 1 New member
    Hi Jonas
    Did you solve your problem with custom filegroups?
    · Share on Twitter
  • Options
    JonasGJonasG Posts: 11 Bronze 1
    Yes, in removed the usage of custom file groups for text/image columns, for internal usage.

    Steps to clean up 'MyTable':
    1. Drop keys for 'MyTable' (ForeignKey + PrimaryKeyUnique)
    2. Rename table (exec sp_rename 'MyTable', 'MyTableOld';)
    3. Create new table on default (textimage_on [PRIMARY])
    4. Copy data to new table
      (insert into dbo.MyTable (x, y, z) select x, y, z from dbo.MyTableOld;)
    5. Add keys to new table (PrimaryKeyUnique + ForeignKey)
    6. Add default constraints and documentation (same as MyTableOld)
    7. Drop old table (drop table [dbo].[MyTableOld];)
    8. Empty custom file (dbcc shrinkfile (MyFileName, emptyfile);)
    9. Remove file (alter database DDM_Content remove file MyFileName;)
    10. Remove file group (alter database DDM_Content remove filegroup MyFileGroupName;)
    In repository, no file groups.
    At customer site use custom file groups as before.
    · Share on Twitter
Sign In or Register to comment.