Setting Autgrowth setting

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

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.

Gary
Garymazzone
 
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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests