Only storing part of a DB

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

Only storing part of a DB

Postby bermudabob » Wed May 28, 2014 1:51 pm

I've got a DB that is controlled by a third party and do not want to store most of it. We have added a couple of triggers (yuck) to various tables so we can extract any required data we need. All I really want to put in source control are these triggers.

I've linked the DB to SQL Source Control as normal and only ticked the the tables that contains the triggers I want.

My question is, is there any way to set the source control to stop showing the rest of the database in the Commit changes tab? Ideally, I'd like a way of telling source control that this current status is a baseline, and only to offer to commit changes from this position.
Rob Marsh

Aero Developer
Scuderia Toro Rosso F1 Team.
bermudabob
 
Posts: 3
Joined: Thu Apr 17, 2014 4:11 pm

Postby David Atkinson » Fri May 30, 2014 2:01 pm

There's a filter feature that lets you exclude object types, which should do the trick:

http://documentation.red-gate.com/displ ... de+objects

Let us know if this isn't what you're looking for.
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest