Deploy 1 package to multiple databases on same server


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)StrataFrame User (276 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
Hi guys,



I'm trying to do the above. I've looked at the sampledatainstaller and DatabaseMigratorClass info. Still have a few questions though.

1. Is it possible to install a database to a filegroup programmatically? IOW supply the value at runtime?

2. How can I select a database to apply a profile script to that's not in the drop down? Is it possible to change that value on the fly as well?

3. If I want to do a Grant EXEC on PPMUserSecurity_Delete to SOMEID in the script for stored procedures, is it possible to pass in the SOMEID value on the fly?



Thanks
Reply
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (938 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
Yep, you are right. I went in and reproduced it and we aren't accounting for wildcards when we check for duplicate physical file names.

We've corrected it, and the correction will go out with the next build.  In the mean time, the work around is to add anything to the wildcard to make it a unique name for the profile. So instead of the default "$DbName$", change the second database to "$DbName$_Standard" or anything else unique for the profile and it will allow you to save the record and deploy.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search