Run SQLPackager as upgrade

[Garymazzone]

I have created a new package to add users to a database from a script. The exe works fine if I run from the GUI selecting the Upgrade an existing database option and select the database to run against.

How can I do this from the command line:

I have tried the following:
addusertest /server:usd503\sql2008 /database:serviceshub /rundb:serviceshub -- Fails wit database already exists

addusertest /server:usd503\sql2008 /rundb:serviceshub -- Fails wit database already exists

So how do I execute the package to perform an upgrade and not create a new database?

[Brian Donahue]

Hi Gary,

We have got a patched installation of SQL Packager (v6.0.1.9) that fixes this bug, so that a package will only create a database when the /makedatabase option is used. Please contact support@red-gate.com if you need this update. Since it's untested, we are only distributing the update if it's absolutely necessary.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521