I am working with a team of 5 persons. We are using SQL Server as our database. Since long time I want to store the Stored Procedures in SVN so that the versions can be maintained. Is there any tool which can be used as a plugin with SQL Server Management Studio and allows checkin from there.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Sounds like Red Gate's SQL Source Control might be what you're looking for.
It says it connects to "TFS, SVN, SourceGear Vault, Vault Pro, Mercurial, Perforce, Git, and any source control system with a capable command line," and that it "links your databases to your existing source control system straight from SSMS".
I haven't used it personally, but I have used other Red Gate SQL tools, and they have been excellent.
SSDT projects are great for this these days.
You keep all your db & proc & function definitions in script files (which define your model) and within Visual Studio sync the model with your database / publish to a database to update it. As all your object definitions are in script files you can have them under source control using SVN/Hg/whatever.
If I remember correctly (it's been years since I've used SQL Server), you can execute external scripts using
For each stored procedure, I'd write a sql script that removes the current one (if it exists) and creates the new version. Saving these in external
Obviously you'd want to create a backup of your current database prior to running your script in case all goes to hell.