Just played around the stored procedure properties window. I would be grateful, if it provide an SQL Preview tab in Stored Procedure Properties, as the user can then just use the SQL Preview script to create the stored procedure.
Another that would be good is at the moment we cannot use some function like undo/find/replace on the SQL tab on “Stored Procedure Properties” windows. I think it would be helpful to have that kind of function on the SQL tab. I think it would to good to have though feature in Notes, Procedure Comment… etc All the tab/ windows that allow user to enter/edit text. E.g. sometime user may want to do a bulk replace to specific text or something. Another thing I would like to talk about is, (This apply to all the properties window) At the moment if you accidently changed something, but you do not want to save it, and what you want to do is to use the drop down list at the top of the properties windows, to modify something else on the other entity/attribute or something else. (At the moment the drop down list will be grey out, as you have modified some of the field so you have to either undo all the changes and click on apply then use the drop down list to navigate to the other entity/attribute/other stuff OR you need to click “Cancel” to cancel all the changes you made and then open up the properties windows again and use the drop down list to find the stuff that you want to change. I think it would be better not to grey out the drop down list, instead it will prompt to ask if you want to save the changes or not when you click on the drop down list (this message only display if the apply button is active or something which mean it detected you have changed something but have to apply the changes. I think this could resolve the issue on when you accidently changed something you do not want to change, you have to undo and click on Apply or click on cancel and load up the properties windows again.
I am wondering if it is possible to make Procedure visible on the workspace? so that we do not need to go to the Physical Model Explorer to modify the Procedure.
Would it be possible to convert the stored procedure from one database to the other? E.g. MSSQL to MySQL?
Please let me know if you want me to explain more.