Command Line Script Error

[creejohson]

Hi --

I'm trying to execute a package from the command line and want to upgrade an existing db. The arguments I'm using are below:

/server:myserver /database:mydb /username:myuser /password:mypassword /quiet

This fails with error: CREATE DATABASE permission denied in database master

I read in the forum that giving the calling user those permissions will allow the script to be run successfully. I don't have that luxury unfortunately. Is there another way to execute an upgrade using this tool?

Thanks
Chris

[Matthew Flatt]

Hi Chris,

What permissions does the user that will want to run the upgrade package have?

The CREATE DATABASE permission should only be needed for a new database package and not an upgrade package.

Thanks,
_________________
Matthew Flatt
Test Engineer, HyperBac

[nnodari]

Matthew Flatt,

When we choose a "Package a Script" project the command line execution always try to "create a database".

i have the same problem...

There should be an argument as /upgrade, instead of /makedatabase
_________________
Att

[creejohson]

The user has database owner privileges, but they don't have any other server-wide privileges. They can run the package fine from the GUI but not from the command line...same issue as nnodari. If there was a /makedatabase:false switch or the switch nnodari suggested perhaps that would solve the problem.

[Brian Donahue]

Hi Chris,

There is a bug in SQL Packager that is causing a database to be created whenever an existing script is packaged. The workaround for this is described in our knowledge base.

Sorry for the inconvenience.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521