Running SQL Packager from Command Line

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Running SQL Packager from Command Line

Postby rkhorkp » Fri Sep 08, 2006 12:38 am

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
rkhorkp
 
Posts: 6
Joined: Thu Oct 13, 2005 5:52 pm
Location: Tulsa, OK

Postby Brian Donahue » Mon Sep 11, 2006 6:31 pm

Hello,

Maybe the old DOS trick of redirecting the output would help?
Code: Select all
sqlpackagetest /server:BRIAN /database:test /makedatabase /quiet > NUL:


Sending the output to NUL: will cause the command-line interpreter to eat the output instead of writing it to the console.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby rkhorkp » Mon Nov 13, 2006 8:40 pm

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?
rkhorkp
 
Posts: 6
Joined: Thu Oct 13, 2005 5:52 pm
Location: Tulsa, OK

Postby Brian Donahue » Tue Nov 14, 2006 11:34 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby B Aho » Tue Mar 20, 2007 12:47 am

Brian Donahue wrote: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,

We're also having the same issue... I didn't see this thread until after I posted a new one. (Oh well, it is sure to be seen now...)

The previous version worked fine... it was only after we went to version 5 that this became a problem for us.

Surely this was an oversight in version 5 that can be corrected somehow?

This is becoming an issue for us to the point that we may need to consider other tools.

Thanks,
Bryan
B Aho
 
Posts: 5
Joined: Mon Mar 19, 2007 7:32 pm

Postby Brian Donahue » Tue Mar 20, 2007 12:26 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby B Aho » Wed Mar 21, 2007 6:20 pm

Brian Donahue wrote: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.


That makes sense... except for the need for a final dialog with an ok button.

It looks like there is a reply on the other thread that describes how to suppress the dialog... I'll give that a try.

Thanks for the assistance! :)
B Aho
 
Posts: 5
Joined: Mon Mar 19, 2007 7:32 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests