Command Line Script Error

creejohsoncreejohson Posts: 3
edited April 2, 2009 10:52AM in SQL Packager Previous Versions
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
· Share on Twitter

Comments

  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    Redgate Foundry
    · Share on Twitter
  • nnodarinnodari Posts: 24
    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
    · Share on Twitter
  • creejohsoncreejohson Posts: 3
    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.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.