Red Gate forums :: View topic - Exclude SIZE parameter from CREATE DATABASE statement
Return to www.red-gate.com RSS Feed Available

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

Exclude SIZE parameter from CREATE DATABASE statement

Search in SQL Packager 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
christiang



Joined: 03 Feb 2009
Posts: 5

PostPosted: Tue Apr 22, 2014 9:53 pm    Post subject: Exclude SIZE parameter from CREATE DATABASE statement Reply with quote

We use sql packager to package a script to create a database for our application. The sql packager exe get called in command line mode from and installshield installer exe. We've come across a customer who uses a model database size greater then the default, and the create statement for the database created by sql packager fails because its specifying a size smaller then the model database size.

Is there a way that we can have sql packager exclude the SIZE parameter from the CREATE DATABASE statement so it uses the default model size as it does for collation, recovery model and compatibility level? That way we can avoid the problem in the future.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Thu Apr 24, 2014 9:56 am    Post subject: Reply with quote

When you create the package using SQL Packager, click the "Extra Package Info..." button on the "create .EXE" screen of the wizard. On the database properties page, set "Database Size (MB)" to an empty value (note: not Zero or anything else, as this will cause an error).

When you run the resulting package, the default new database size will be used.

Hope this helps.
Back to top
View user's profile Send private message
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