Databases
StackOverflow2013
Postsdbo
POCommitting Stored Procedures to SVN Repository
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCommitting Stored Procedures to SVN Repository
    text
    copied!<p>My current development environment for C# projects is Visual Studio, with a SQL Server database and using VisualSVN to connect to my SVN repository. To manage revisions of my Stored Proceduress, Views, etc I save the <code>ALTER</code> script to a folder watched by my SVN client so these get included in the repository. </p> <p>I have checked out some (now older) posts like this one (<a href="https://stackoverflow.com/questions/51288/how-to-keep-stored-procedures-and-other-scripts-in-svn-other-repository">How to keep Stored Procedures and other scripts in SVN/Other repository?</a> and <a href="https://stackoverflow.com/questions/1716360/is-there-a-svn-plugin-for-sql-server-management-studio-2005-or-2008">Is there a SVN plugin for SQL Server Management Studio 2005 or 2008?</a>) and have seen a recommendation for these tools: <a href="http://www.red-gate.com/products/sql-development/sql-source-control/" rel="nofollow noreferrer">http://www.red-gate.com/products/sql-development/sql-source-control/</a> and <a href="http://www.zeusedit.com/agent/ssms/ms_ssms.html" rel="nofollow noreferrer">http://www.zeusedit.com/agent/ssms/ms_ssms.html</a> . </p> <p>As I infrequently work with projects doing much DB-side programming, this has never been a major bother (a dozen scripts in a folder with some naming scheme is not much to manage manually), but I have just inherited a project with a few hundred views and 1000+ Stored Procedures which have never been included in version control. </p> <p>My question is:</p> <p>What process do others follow for managing the versioning of their SQL Server code - is there a an accepted, <em>clever</em> or otherwise obvious approach I am missing here? I am leaning currently towards the purchase of one of the aforementioned tools - but am looking for advice from the community before I do this. </p> <p><em>I realize this may result in a tool recommendation rather than a code solution but posted to SO as I think this is the appropriate crowd to ask this of.</em></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload