Running a Supplied SQL script

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Running a Supplied SQL script

Postby Garymazzone » Tue Oct 06, 2009 6:22 pm

Is it possible to add an SQL script to SQL Packager. I would like to add a script that adds a user and grants permission on the install of a database using SQL Packager 6
Garymazzone
 
Posts: 6
Joined: Tue Oct 06, 2009 6:18 pm

Postby Brian Donahue » Thu Oct 08, 2009 2:31 pm

Hi Gary,

I suppose there are two options. One would be to use Packager to create the scripts, save them to disk, modify them to add your user, and package the scripts into an executable by using SQL Packager again.

There is also an option to save the SQL queries that you want to run to a file, and use the /presql argument to the package executable to run the script before the rest of the package execures.

I hope this helps!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests