Renaming data sources
Hi
We always get into the situation where existing data sources have to be renamed.
It would be nice if this would be available as an option in the DV Studio. I thought this function used to exist but I can't find it in our environment (4.0.8).
Also, it would be handy if there was another option where all objects that appear in the dependency tree would also point to the newly renamed version.
-
Hi Sebastian,
Thanks for your feedback and sorry for the late reply.
You are right, this functionality was available in one of the older versions of Data Virtuality Studio. However, we decided to remove it quite some time ago because it was not working as expected in some scenarios.
Renaming and replacing references to existing data sources used in simple SQL code of views and procedures where the data source name can be easily resolved to the corresponding "entity" is quite straightforward. But when the data source name appears, for example, in dynamic SQL commands (e.g., EXECUTE or EXECUTE IMMEDIATE), it's not so easy to do the same.
We appreciate your feedback and will take it into consideration when we will revisit this functionality.
Best
Salvatore
Please sign in to leave a comment.
Comments
1 comment