Ability to add scripts that manipulate data to do particular data activity before or after changes are made to another environment. For instance if we identified duplication of data there would be data cleansing script as well as new index. Dashboard will show the new index but script to clean data will remain in source control or folder and can easily be missed in deployment.
I am looking for single point of integration to see manual scripts as well as DDL detected changes.
Ideally all of these would be integrated with source control. For instance redgate source control allows adding migration script but according best of my knowledge no other tools are able to see these scripts so we need to keep track manually to ensure our build does not miss them.