Red Gate forums :: View topic - Feature: Drop/Create for stored procedure synchronization
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Feature: Drop/Create for stored procedure synchronization

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
csuire



Joined: 01 Feb 2008
Posts: 6

PostPosted: Fri Feb 01, 2008 7:30 pm    Post subject: Feature: Drop/Create for stored procedure synchronization Reply with quote

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/viewtopic.php?t=2747#top

Thanks!
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Mon Feb 04, 2008 12:20 pm    Post subject: Reply with quote

I've added this forum thread to the feature request covering this behaviour.
Back to top
View user's profile Send private message
jhogan



Joined: 23 Sep 2009
Posts: 7

PostPosted: Wed Sep 23, 2009 6:52 pm    Post subject: I second Reply with quote

I second...
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?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Wed Sep 23, 2009 8:49 pm    Post subject: Reply with quote

We're looking closely at feature and actively looking for user requirements in this area. If there are any more examples of what you'd want the generated script to look like if we added a "Make scripts rerunnable" option, please let us know what they are. Is it only ever Stored Procedures that may already exist on the target server, or are there other objects or object properties that you need to check for existence?

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Fri Oct 28, 2011 12:02 pm    Post subject: Reply with quote

We have options for rerunnable scripts in the latest Beta.

would you be able to let us know if this meets your requirements?

http://www.red-gate.com/MessageBoard/viewtopic.php?t=14113

Kind regards,

David
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group