Does SSC3 handle custom scripts?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Does SSC3 handle custom scripts?

Postby adam12 » Thu Apr 25, 2013 10:45 am

Hi, I have just installed your tool and checked help/sample video but I haven't found way how can I commit my custom script - is it possible?

My situation looks like following:
1) Initial commit with database objects
2) Some Update script - where this should be placed? this script for example disabled all users in table - and what if I have many custom scripts and they must be executed in order?

Thanks in advance
adam12
 
Posts: 1
Joined: Thu Apr 25, 2013 10:37 am

Postby Brian Donahue » Mon Apr 29, 2013 1:50 pm

Hello,

SQL Source Control is designed to turn a database into individual scripts that go into a version control system, so it is not really designed to allow you to put scripts in-line with those created by Source Control.

However, you may be able to leverage migration scripts - these are commands you can slip into the deployment updates. Please see:
https://documentation.red-gate.com/disp ... ns+scripts
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest