/quiet command-line switch

[B Aho]

Hi,

Our installation calls out to a SQL Packager 5 EXE which installs our database.

We like the fact that when you run it without the /quiet switch, it gives you a progress bar with status messages. If an error occurs, it shows up in a nice error dialog, which is helpful to our field personnel.

However, once successful--at the end, it forces you to click OK on a dialog that says database creation completed.

When we invoke the EXE with the /quiet switch, we lose all of the nice progress bars and error information.

Is there a way to not use the /quiet switch but also to not get the ok dialog at the end? If so, we'd probably want to run the EXE that way.

Thanks,
Bryan

[James Moore]

Hi Bryan,

You can achieve this fairly easily - SQL Packager compiles up the executable from a set of C# files in the SQL Packager Code Templates directory in C:\program files\red gate\sql bundle 5\ directory.

To suppress the message box if you find the file PackageMain.cs and search for the line:

PackageUtils.ShowMsg(new PackageExceptionInfo("Package executed successfully."));

you should see the following code:

if (result == 0)
{
PackageUtils.ShowMsg(new PackageExceptionInfo("Package executed successfully."));
}

If you remove these three lines and recreate your package it should then work fine without showing the message box on completion.

Hope this helps,

- James
_________________
James Moore
Head of DBA Tools
Red Gate Software Ltd

[B Aho]

[James Moore]

Yep,

if he makes the change in his program files directory it will happen for all future packages.

- James
_________________
James Moore
Head of DBA Tools
Red Gate Software Ltd