The tag has no wiki summary.

learn more… | top users | synonyms

24
votes
4answers
950 views

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 ...
12
votes
7answers
1k views

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 ...
6
votes
2answers
3k views

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 ...
4
votes
1answer
4k views

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 ...
3
votes
6answers
1k views

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 ...
3
votes
2answers
85 views

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 ...
2
votes
0answers
57 views

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 ...
1
vote
2answers
77 views

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 ...
1
vote
0answers
113 views

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 ...
0
votes
1answer
417 views

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 ...