Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [source-control]

Source control for database structural and code components.

Use this tag for questions about maintaining source control over database structure and code components.

This may include questions tracking DDL changes within a database itself.

25 questions
31
votes
5 answers

Is there a "best-practices" type process for developers to follow for database changes?

What is a good way to migrate DB changes from Development to QA to Production environments? Currently we: Script the change in a SQL file and attach that to a TFS work item. The work is peer-reviewed When the work is ready for testing then the SQL…
Beth Lang
  • 952
  • 1
  • 10
  • 19
20
votes
9 answers

Version control for database objects

The database our developers are working on is too large (have a lot of database objects). We have to control db objects changes (change management). Our company cannot have a person who would be responsible for db changes only. So we need a source…
garik
  • 6,782
  • 10
  • 44
  • 56
19
votes
7 answers

Stored Procedures under Source Control, best practice

I am currently using Tortoise SVN to source control a .NET Web Application. What would be the best way to bring our SQL Server stored procedures into Source Control? I am currently using VS 2010 as my development environment and connecting to an…
QFDev
  • 789
  • 1
  • 9
  • 21
9
votes
1 answer

How do you install a TFS plugin for SQL Server 2016 Management Studio?

How do you install a TFS plugin for SQL Server 2016 Management Studio? The source control option is no longer in the option list so the existing workarounds no longer appear to work.
GordyII
  • 263
  • 3
  • 4
8
votes
3 answers

How to extract Procedure, Function, etc. Source Code from an Oracle Export

I have generated an EXPDAT.DMP file of an Oracle database with the command: exp userid=usr/pass@db owner=own rows=n compress=n I then ran the following command to generate a file containing the 'Create Table...' statements: imp userid=usr/pass@db…
MatthewToday
  • 325
  • 2
  • 3
  • 7
5
votes
1 answer

Visual Studio, GIT, and SQL Scripts

I am trying to figure out a way to have all of our random SQL scripts that we write under source control. I am already using SSDT for the database project. This is not for these sort of scripts. It is for all the other random queries that we run…
Anthony Genovese
  • 2,067
  • 3
  • 22
  • 34
5
votes
1 answer

TFS2010 for SSMS 2012

SSMS 2012 does not work with VSS 6. We installed modern source control, TFS 2010 server. Then I Installed Team Foundation Server MSSCCI Provider 2010. However the only choice for Source control plug-in in SSMS 2012 is still VSS6. My VS2010 works…
ob213
  • 654
  • 1
  • 9
  • 19
4
votes
1 answer

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL Data Warehouse. The prior approach for change…
John Hargrove
  • 149
  • 1
4
votes
1 answer

How to develop a database (workflow)?

tl;dr: I know a few SQL semantics and I know how databases work (basically) but I never created one that had a considerable size. I lack of knowledge concerning workflow, SQL-code management and very basic SQL programming practices (write by hand or…
Stefan Falk
  • 165
  • 8
3
votes
0 answers

Branching Source Control at development

At my current employer, the developers are branching for development per story and merging for release in Git - and frankly I'm jealous. ...but I haven't been able to wrap my head around how a SQL Server DB workflow should work in this manner,…
lackadaisql
  • 31
  • 2
3
votes
2 answers

With the advent of integrated source control, do stored procedure changes still need comments?

Back in the old days, my team had a policy that any stored procedure modification required comments in two places: Top of the stored procedure with an overall summary of the changes made Comments on each line where the change was made It…
8kb
  • 2,639
  • 2
  • 32
  • 36
3
votes
1 answer

SQL TFS Visual Studio Solution: One Database or Multiple Databases

When creating a TFS Visual Studio 2017 solution with SQL Server 2016, should the solution contain one database project per solution, or multiple database projects in a single solution? Our system has databases which are interlinked/cooperate in…
user129291
2
votes
1 answer

SELECTs in Database Change Log and Source Control

We are overhauling the way that we store our database in source control and keep a change log of it. I was reading the following article: http://thedailywtf.com/articles/Database-Changes-Done-Right, and in the Short Section of "The Taxonomy of…
Gander7
  • 197
  • 1
  • 5
2
votes
4 answers

How does SMO make it easy to grab all code on a Microsoft SQL Server?

There has recently been a lot of talk about putting database code in source control. I have read widely on this topic and there appears to be an unstated assumption that using SMO through PowerShell makes it very easy to do the following…
J. Mini
  • 1,161
  • 8
  • 32
2
votes
1 answer

Invalid object name 'ApexSQL.ApexSQL_SourceControl.Objects'

I was trialing Apex source control - trial ended. Uninstalled Apex (well I thought I did). Today I deleted the Apex database. Now I get Msg 208, Level 16, State 1, Procedure ApexSQL_SourceControl_DDLTrigger, Line 72 [Batch Start Line 7] Invalid…
Ben Watson
  • 111
  • 10
1
2