Devart Forums

Hello,
I have tried to update some procedures, but when I obtain the synchronization script I have seen that it always first drop procedures and then create them, but not make the logical and only step (alter procedure)....how can I configure to obtain the alter proc in script??

Thanks

Please have a look at: http://dev.mysql.md/doc/refman/5.0/en/a ... edure.html

"This statement can be used to change the characteristics of a stored procedure. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE."

I use SQL Server 2008R2....I usually use alter proc to change the body of a procedure

In case the aplication only drops and creates the procedure, how can I configure the synchronization script to include the permissions of each procedure??

Please ignore the last our post.

We will review the issue regarding altering existing procedures instead of dropping and recreating them when developing next versions of the product.

Currently, we suggest you to leave the option 'Ignore permissions' unchecked on the 'Options' page of the 'New Schema Comparison' wizard.

Ok, thanks a lot....I will try unchecking that option

It was successfull but I have another similar problem....when I need to create a new procedure with this option the application doesn´t include the permissions of new procedures....how can I configure it??

We will review this case when developing next versions of the product.

Ok, thank you....is there any way of writing all the operations made by the script at the results window of ssms??
Right now I only receive "Command(s) completed successfully."

Could you please provide us an example of such operations?

When I used Visual Studio for schema comparing, it introduces the operation at the window results using:
PRINT N'Creating [dbo].[procedure_example]'

I don´t Know if it is possible with dbforge or something similar like printing the action plan in that window...

We will review this suggestion when developing next versions of the product.

I have tried to update some procedures, but when I obtain the synchronization script I have seen that it always first drop procedures and then create them, but not make the logical and only step (alter procedure)....how can I configure to obtain the alter proc in script??

This behavior is changed in the new builds of the products:

http://www.devart.com/dbforge/sql/schem ... nload.html
http://www.devart.com/dbforge/sql/studio/download.html