How to use git as source control provider for SQL Server Management Studio [closed]
Can we use GIT as the source control for sql management studio?
for Database source control within SSMS
Agent SVN - SCC Subversion Plug-in. http://www.zeusedit.com/agent/ssms/ms_ssms.html
or
http://www.red-gate.com/products/sql-development/sql-source-control/
I’ve found out that ApexSQL has a tool that natively supports Git as a source control system. It comes as a SSMS add-in, and offers a wizard you can use to map database objects with the source control systems. To do that:
- Download and install ApexSQL Source Control
- Start SSMS and in Object explorer select the database you want to be linked to a source control
- Right-click the database, and form the context menu, select the Link database to source control option, from the ApexSQL Source Control submenu
- Select the source control system (in your case it is Git) and choose from 2 database development models - shared or dedicated. Shared model is recommended when you link a database on which multiple developers will work at the same time
- Filter objects which you don’t want to track using source control: by schema, type or name by schema, type or name
- Provide appropriate login information and repository string. For Git it is:
<protocol>://<hostname>:<portnumber>/<Git server name>/<repository>
(see example below):
More detailed step-by-step instructions can be found in this article: http://knowledgebase.apexsql.com/link-database-source-control-system-2/
Try sql-source-control
, a free and open source CLI used to get SQL into source control systems like Git.
https://www.npmjs.com/package/sql-source-control