Script generation

pkettlew · February 24, 2016 8:53PM

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

Sergio R · February 26, 2016 6:48AM

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,

pkettlew · February 28, 2016 8:00PM

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

Sergio R · March 2, 2016 4:11AM

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,

Script generation

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk