Feature: Drop/Create for stored procedure synchronization
csuire
Posts: 25 Bronze 3
Add new Project Behavior:
"Do not use ALTER to modify stored procedures or views"
Description:
When this option is selected, SQL Compare will drop and then create any stored procedures and views that are to be synchronized rather than using the ALTER method. This will create the "if exists() drop..." sql code even if the stored procedure is being added for the first time.
Example Output:
This is similar to scripting stored procedures from Enterprise manager.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExampleStoredProcedure]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ExampleStoredProcedure]
GO
CREATE PROCEDURE [dbo].[ExampleStoredProcedure] ...
Please note that this feature request is similar to this previous post:
http://www.red-gate.com/messageboard/vi ... t=2747#top
Thanks!
"Do not use ALTER to modify stored procedures or views"
Description:
When this option is selected, SQL Compare will drop and then create any stored procedures and views that are to be synchronized rather than using the ALTER method. This will create the "if exists() drop..." sql code even if the stored procedure is being added for the first time.
Example Output:
This is similar to scripting stored procedures from Enterprise manager.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExampleStoredProcedure]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ExampleStoredProcedure]
GO
CREATE PROCEDURE [dbo].[ExampleStoredProcedure] ...
Please note that this feature request is similar to this previous post:
http://www.red-gate.com/messageboard/vi ... t=2747#top
Thanks!
Comments
Redgate Software
We need this feature because we can make only a limited number of assumptions about the target databases. We can't assume that procs will exists. ALTER's have caused scripts to fail for us in the past because the proc didn't exist.
Is there anyway I can check the status of this feature request?
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
would you be able to let us know if this meets your requirements?
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
Kind regards,
David
Product Manager
Redgate Software