Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [source-control]

Source control for database structural and code components.

Filter by
Sorted by
Tagged with
0 votes
2 answers

About version control on the programming scripts of SQL Server, e.g., stored procedures and functions

We have an instance of SQL Server (MSSQL) version 2016, and the database contains programming scripts, e.g., stored procedures and functions. For the programming scripts of MSSQL, we wonder how to do ...
James's user avatar
  • 149
-1 votes
2 answers

Tool to Execute SQL Server Scripts and Automatically Recognize and Prompt for Scripting Variables [closed]

I have a folder of scripts that contain multiple objects and jobs that I roll out every time I deploy a new SQL Server Instance. The scripts utilize scripting variables, as an example, here is an ...
SE1986's user avatar
  • 1,970
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 ...
Ben Watson's user avatar
1 vote
0 answers

Integrating Flyway and Github [closed]

I was wondering if any of you can share some experience regarding integrating Flyway and Git. We're currently developing a project, each sprint we need to make database changes for new features of ...
browsingThrough91's user avatar
0 votes
2 answers

Proper way to add new column in database

What is the proper approach when we add a new column into an existing table? For example, I already have columns like, Foo1, Foo2, Bar1, Bar2. Now I want to add a new column called Foo3. What is ...
JackLock's user avatar
  • 468
1 vote
1 answer

SQL SSDT Database Projects: Source Control Lookup Data

Does SQL Server SSDT Visual Studio 2017 Database Projects support Source control data for lookup tables, or do we still have to utilize messy Post-Deployment Merge Scripts for multiple tables? ...
user avatar
3 votes
1 answer

SQL TFS Visual Studio Solution: One Database or Multiple Databases [closed]

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 ...
user avatar
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 ...
John Hargrove's user avatar
5 votes
1 answer

Visual Studio, GIT, and SQL Scripts [closed]

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 ...
Anthony Genovese's user avatar
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's user avatar
  • 263
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 ...
Stefan Falk's user avatar
1 vote
0 answers

source control for SQL Agent Jobs

Our SQL Agent jobs execute different DTSX packages at various steps. e.g: \\DEVLserver\DTSX\package1.dtsx I want to keep the agent job script in TFS but when I promote it is there any way to change ...
user65883's user avatar
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:, ...
Gander7's user avatar
  • 197
0 votes
1 answer

databases cross references baselines

We have on several databases on same instances, some stored procedures have references to tables on other databases. We are in the middle of a big project to take our database under source control. ...
Yaroslav's user avatar
  • 2,826
1 vote
0 answers

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
Fulproof's user avatar
  • 1,382
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 ...
lackadaisql's user avatar
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 ...
QFDev's user avatar
  • 789
0 votes
1 answer

Deploying to an existing database from VS 2010 on TFS

I am trying to find a way in VS2010 to add a few objects to an existing database without scripting out all of the existing objects. This is a maintenance project that is adding a table, altering an ...
William Salzman's user avatar
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 ...
8kb's user avatar
  • 2,629
1 vote
2 answers

Consolidating data changes in SQL Server by team

What is a good way to manage developers' data changes? I am using RedGate SQL Source Control to monitor changes to tables and stored procecures, so that when we do a production build, I can include ...
Dina's user avatar
  • 1,497
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-...
ob213's user avatar
  • 634
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 ...
garik's user avatar
  • 6,732
7 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 '...
MatthewToday's user avatar
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 ...
Beth Lang's user avatar
  • 952