Red Gate forums :: View topic - Running a Supplied SQL 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

Running a Supplied SQL script

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



Joined: 06 Oct 2009
Posts: 6

PostPosted: Tue Oct 06, 2009 6:22 pm    Post subject: Running a Supplied SQL script Reply with quote

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



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Thu Oct 08, 2009 2:31 pm    Post subject: Reply with quote

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!
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