Skip to main content

All Questions

Filter by
Sorted by
Tagged with
3 votes
4 answers
2k views

Database modeling, software development, and version control

Here is the framework We have an SQL database in which our database model lives in. On the other side, there is a bunch of code using and filling that database. Here is what we want We want to put ...
Tobias Windisch's user avatar
1 vote
0 answers
823 views

Best way to handle multiple environment specific sql scripts in source control

I am maintaining an app that uses a lot of sql server 2008r2 stored procs, views etc. The problem that I have is that certain stored procedures/views have code that is specific to the environment: ...
boggy's user avatar
  • 141
10 votes
3 answers
970 views

How do I Integrate Production Database Hot Fixes into Shared Database Development model? [duplicate]

We are using SQL Source Control 3, SQL Compare, SQL Data Compare from RedGate, Mercurial repositories, TeamCity and a set of 4 environments including production. I am working on getting us to a ...
TetonSig's user avatar
  • 471
12 votes
2 answers
10k views

How can I keep my visualstudio database project in sync with my database?

I'd like to have my database schema synchronized with my Visual Studio .dbproj database project. Right now, I'm using SSMS for most of my database development work, and I've to manually use the ...
Brann's user avatar
  • 656