Running SQL Packager from Command Line

[rkhorkp]

This is what I currently am using:

I have an .net application that
1. runs the SQL Packager from command line to create a temp database.
2. runs sql compare on certain tables between production database and the temp database.
3. runs sql data compare on certain tables between production database and the temp database.
4. delete the temp database.

When I was using an older version, I was able to run this without any user interaction. But now, with version 5, after creating the temp database, there is a prompt that says package is successfull. Can this be remove?

I tried using the quiet mode, but when it does that, there is no indication of work being done. I like how it was in version 1.1 where at the end of the process, there is no prompt and I was able to show the progress of running the package.

Hope this make sense.

Thanks

[Brian Donahue]

Hello,

Maybe the old DOS trick of redirecting the output would help?

[rkhorkp]

Thank you Brian for the tip. This does not work for me. I like the progress indicator with 5.0, but just not the last message box that comes up when the process is complete.

Is there ay way for me to get the progress indicator, but not the ok message box that come up at the end?

[Brian Donahue]

Hi,

I'm guessing that the quiet option suppresses both the progress bar and the completion message. If that's the case, it looks like an all-or-nothing deal.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[B Aho]

[Brian Donahue]

Hello,

Version 5 changed the package format from a Windows Form application that supported writing messages to the console to a console application that can launch a Windows form. The other design presented problems with console messages, and this is why the change was made.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[B Aho]