How do I add existing SQL Server stored procedures to source control?
Right now we have a bunch of database servers with stored procedures running in them that are poorly documented and exist nowhere else.
When a change is made to one, there is no log, and it's really hard to figure out why something that was working suddenly fails.
We've recently switched to using proper version control using SVN, so I was hoping to add these stored procedures to version control.
We are a .Net shop, and I'm aware that there exists a Database project type. Would that be a good approach?
Alternatively I could just keep the stored procedures as text files and operate on those, but I'm wondering about the annoying deployment steps involved with doing so.
In Visual Studio, I created an empty project and added the scripts to it. Its part of my server schema solution. Now every single script in under source control. I also added a folder structure as well to try and keep the sanity. When the application is finished we will have probably close to 3000 scripts under source control under multiple server schemas. Not saying this is the best, but it is working for our project. The solution also has a utility which uses SMO to actually run/deploy all the scripts, so everything is contained in one solution. Screen shot attached showing some of the structure for your reference...
- Quartz.net: How to create jobs using Dependency Injection
- MemoryStream - Cannot access a closed Stream
- Custom Compiler Warnings
- Cannot find Assert.Fail and Assert.Pass or equivalent
- How to reduce the margin between two buttons in below WPF code
- Bad Request When Using PostAsJsonAsync C#
- How to use RouteValues using MvcPaging2.0 in MVC3?
- How to change visibility for some TreeDataGrid rows?
- Dynamically Added LinkButtons Don't Fire OnClick Event
- How to retrieve actual item from HashSet<T>?
- Retrieve 10 records from MySQL?
- Entity data model designer won't open the edmx file
- How can you inherit from a sealed class using reflection in .Net?
- Azure .NET SDK: Scale Azure SQL databases through SDK
- SortedList Doesn't taking multiple objects in C#
- Using System.Text.Json to Serialize an IConfiguration back to Json
- In v8 of highcharts implemented multiple highcharts in a single view but not working in the upgraded version GetHighchartsJS
- IBrowserFile FromIMageFileAsync incomplete image
- Can't repoduce call stack in one of my programs
- What's the fastest way to read a text file line-by-line?
- What is the difference between Environment.CurrentDirectory and Directory.GetCurrentDirectory?
- Automapper: passing parameter to Map method
- What is the difference between String and string in C#?
- error MSB3073: The command "npm install" exited with code 1
- What's the algorithm behind Robocopy?
- ASP. NET Core 8: Error HTTP 500 and returnurl=%2F in the URL
- Decompressing Large Gzip File not working using System.IO.Compression
- mlContext.Data.CreateEnumerable uses the init property?
- Why should I prefer single 'await Task.WhenAll' over multiple awaits?
- Implicit casting / polymorphism with a Dictionary in C#