Dynamically modifying script

jrl124cjrl124c Posts: 3
edited November 28, 2008 10:00AM in SQL Packager Previous Versions
Can SQL Packager be set up to get user input and then modify SQL script based on that. Specifically, when we install a db, we want to allow the user to specify the Database name and the replace the default name with the user-specified database name.

How would that be done?
· Share on Twitter

Comments

  • Michelle TMichelle T Posts: 566 Gold 1
    When you run a SQL Packager package (without using the /quiet switch), it prompts you for server and database information for the database you want to create or upgrade - this is filled in with the default values given when creating the package, but can be changed by the user.

    You can also specify the new database name on the command line with the /database switch.

    Is that what you wanted to know, or have I misunderstood your question?
    Software Developer
    Redgate Software
    · Share on Twitter
  • jrl124cjrl124c Posts: 3
    Yes, that helps. But also can the name the user entered then be used to replace a symbolic variable throught the script?
    · Share on Twitter
Sign In or Register to comment.