Dynamically modifying script

[jrl124c]

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?

[Michelle Taylor]

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?

[jrl124c]

Yes, that helps. But also can the name the user entered then be used to replace a symbolic variable throught the script?