Add support for the $DbName$ in Pre/Post profile scripts in DDT


Author
Message
Edhy Rijo
E
StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Trent,

If would be very nice to be able to use the $DbName$ variable in the Pre/Post profile scripts so we can use it in our generic scripts. 

Also the Pre/Post profile script has an "Execute on Database" combobox with a list of the databases to be use for this script, usually I select the right database name, but sometimes when deploying the profile using $DbName$ the actual database would be different than the one selected in the profile script and the retullts log will not show which database the script was executed on, here is a sample from the log:

• 8/11/2012 11:24:21 PM    -> Finished verifying databases on server.
• 8/11/2012 11:24:21 PM    -> Executing Post-Deployment Scripts
• 8/11/2012 11:24:30 PM    -> Executing Post-Deployment Scripts - Complete
• 8/11/2012 11:24:30 PM    -> The meta data conversion to the SQL Server has been completed.


Edhy Rijo

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