Stored Procedures under Source Control, best practice
19
votes
7
answers
33157
views
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 off-premise SQL Server 2008 R2 database using SQL Server Data Tools (SSDT).
What I have been doing in the past is saving the procs to a .sql file and keeping this files under source control. I'm sure there must be a more efficient way than this? Is there an extension I can install on VS2010, SSDT or even SQL Server on the production machine?
Asked by QFDev
(789 rep)
Mar 26, 2013, 04:03 PM
Last activity: Jan 29, 2016, 10:57 AM
Last activity: Jan 29, 2016, 10:57 AM