Setting Autgrowth setting

Forum for users of SQL Packager database archive utility

Setting Autgrowth setting

Postby Garymazzone » Thu Oct 08, 2009 8:33 pm

Is it possible to set the autogrowth option for database files using SQL Packager?

I have the Soruce database set to grow at 100M but the created database always gets set to 1M I need to set this to a larger size or to some percentage.

Posts: 6
Joined: Tue Oct 06, 2009 6:18 pm

Postby Chris Auckland » Mon Oct 12, 2009 3:51 pm

Thanks for your post.

There isn't a way to set this through the UI, but you can configure it if you output the project as a C# project. Or if you edit the SQL Packager code templates.

You can edit the string used to create the database in the PackageExecutor class.

An easy place to add the autogrowth settings is when the size of the databse gets set. If you search for SIZE= (about line 289) and then add the settings. e.g.

temp += ("SIZE=" + newDatabaseSize + ", MAXSIZE = UNLIMITED, FILEGROWTH = 10%, ");

I hope this is helpful.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests