command line setting database location how to ?

rlmiller9rlmiller9 Posts: 4
edited November 8, 2005 9:05AM in SQL Packager Previous Versions
How can I fill in the "database directory" and the "log directory" with defaults when running from the command line ?

This is of course off of the advanced make a new database dialog.

Thanks
Ray :roll:
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    Running a package from the command line does not allow you to specify the database and log file locations explicitly. You'd need to work around this possibly by running a create database command using osql.exe in the script first and then not using the /makedatabase switch on the package.
    · Share on Twitter
  • rlmiller9rlmiller9 Posts: 4
    defaults ?
    Have not gotten that far yet, but thought about it a bit and suspected that might be the utility of the C# project ?


    THanks
    Ray :P
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Yes -- from what I can tell it would try to use the values that are filled in from the text boxes. You definitely can't specify these on the command-line, though, which would be a good idea in my opinion.
    · Share on Twitter
  • rlmiller9rlmiller9 Posts: 4
    what is the use of a silent invisible install if you can not specify all of the arguments ?
    Maybe next version ?
    Got an idea, send me the source and I will do it :)

    Haha
    Ray :D
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Sure!

    c:\program files\red gate sql bundle\sql packager code templates\c#!
    · Share on Twitter
This discussion has been closed.