Red Gate forums :: View topic - Dynamically modifying script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Dynamically modifying script

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jrl124c



Joined: 26 Nov 2008
Posts: 2

PostPosted: Wed Nov 26, 2008 6:20 pm    Post subject: Dynamically modifying script Reply with quote

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?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 525
Location: Red Gate Software

PostPosted: Thu Nov 27, 2008 1:56 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
jrl124c



Joined: 26 Nov 2008
Posts: 2

PostPosted: Fri Nov 28, 2008 4:00 pm    Post subject: Reply with quote

Yes, that helps. But also can the name the user entered then be used to replace a symbolic variable throught the script?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group