Script generation

Hello,

I am new user to SQL Source Control

I would like the scripts that are generated from SQLServer via SQL Source Control to Source Control to include drop statements for dml objects . The default seems only to script as a create without a drop

I would like something like :

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'&#91;DIF&#93;.&#91;usp_GetBookList&#93;') AND type IN (N'P', N'PC'))
DROP PROCEDURE &#91;DIF&#93;.&#91;usp_GetBookList&#93;
GO

CREATE PROCEDURE &#91;DIF&#93;.&#91;usp_GetBookList&#93;
AS

Is this possible to configure this with SQL Source Control so it does ?

thanks

pkettlew February 24, 2016 20:53

Comments

3 comments

Hi,

You can replace the default scripts by using the Migrations feature in SQL Source Control.

Please see below for more information:
http://documentation.red-gate.com/displ ... on+scripts

Thank you,

Sergio R February 26, 2016 06:48

0
Hi,

Thanks for this.

Your suggestion is for Migration Scripts only , I need the script that gets saved into CVS to have a drop / create . Is this possible ?

Thanks

pkettlew February 28, 2016 20:00

0
Hi,

No, the only way to do this is to use Migration scripts.

However if an object with the same definition on the VCS already exists on a target database linked SQL Source Control, the tool will not attempt to create it.

Thank you,

Sergio R March 02, 2016 04:11

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Script generation

Comments

Add comment