Posts

Tracking changes made to the SQL Server Database objects (Version Controlling)

Image
The purpose of this app is to provide source control management (using Github), for changes made to any SQL Server database object. When using this app, it is no longer necessary to manually save and upload files to a repository, which can solve the following problems: ⮚       The d eveloper forgetting to save the file ⮚       The developer saving the file with the wrong name ⮚       The developer manually pushing files to Github When someone changes a stored procedure and compiles it, (which overwrites the existing stored procedure) there is no way to find out what was there earlier other than by retrieving previous backups. This app automatically saves and uploads this data to Github to increase efficiency and general productivity. There are few drawbacks in this approach. ●       If the changes are made manually through the SQL Server Management Studio, the process may not work as expected. For example, if a table is altered, the changes are not recorded as “Alt