Red Gate forums :: View topic - Setting Autgrowth setting
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Setting Autgrowth setting

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Garymazzone



Joined: 06 Oct 2009
Posts: 6

PostPosted: Thu Oct 08, 2009 8:33 pm    Post subject: Setting Autgrowth setting Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Oct 12, 2009 3:51 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group