Script modification

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Script modification

Postby kzakoski » Fri Nov 10, 2006 9:19 pm

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.
kzakoski
 
Posts: 6
Joined: Wed May 17, 2006 11:04 pm

Postby Brian Donahue » Sat Nov 11, 2006 5:27 pm

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.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby kzakoski » Sat Nov 11, 2006 9:33 pm

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.
kzakoski
 
Posts: 6
Joined: Wed May 17, 2006 11:04 pm

Postby cynicszm » Wed Jul 04, 2007 4:30 pm

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?
cynicszm
 
Posts: 5
Joined: Wed Jul 04, 2007 4:23 pm

Postby cynicszm » Fri Jul 27, 2007 8:08 am

Hello? - does anyone from Red Gate monitor these forums??
cynicszm
 
Posts: 5
Joined: Wed Jul 04, 2007 4:23 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests