Red Gate forums :: View topic - Script modification
Return to www.red-gate.com RSS Feed Available

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

Script modification

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
kzakoski



Joined: 17 May 2006
Posts: 6

PostPosted: Fri Nov 10, 2006 9:19 pm    Post subject: Script modification Reply with quote

Can the script that is generated by SQL Packager be modified prior to making the .net executable?

We currently use AppRole security and I would like to replace the default 'p@ssw0rd' with the correct password so when the DB is created, we don't need to drop and recreate the AppRole account and permissions.

Thanks,

Kevin Z.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Sat Nov 11, 2006 5:27 pm    Post subject: Reply with quote

Hi Kevin,

Thanks for asking. Packager doesn't have an option to set the default new login passwords; they are always set to P@ssw0rd.

One possibility may be to save the package as a Visual Studio Project, then try editing the script resource directly inside the project, replacing P@ssw0rd with the password. Another option would be to excluse the users from the package, then create them outside of Packager with a SQL script and run the script using the package's /presql command when you deploy the package.
Back to top
View user's profile Send private message
kzakoski



Joined: 17 May 2006
Posts: 6

PostPosted: Sat Nov 11, 2006 9:33 pm    Post subject: Reply with quote

Thanks, I also tried to exclude the approle, but Packager continues to add it to the script. Either way, it looks like we will need to perform some type of clean-up because there is no way to change the PW for AppRoles within SQL.

Is there any future app enhancement that may allow the modification of user passwords in the scripts? This isn't only a SQL Packager request, the same is needed for SQL Compare, although in Compare I can copy the script and manually run it in a query window.

Kevin Z.
Back to top
View user's profile Send private message
cynicszm



Joined: 04 Jul 2007
Posts: 5

PostPosted: Wed Jul 04, 2007 4:30 pm    Post subject: Reply with quote

We have the same issue using Packager 5.4. and found this topic - with 5000+ views it seems pretty popular but doesn't have a reply from Red Gate.

Is there an enhancement planned to fix this?
Back to top
View user's profile Send private message
cynicszm



Joined: 04 Jul 2007
Posts: 5

PostPosted: Fri Jul 27, 2007 8:08 am    Post subject: Reply with quote

Hello? - does anyone from Red Gate monitor these forums??
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