Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 564
Daniel Mahadi Avatar asked Sep 25 '10 10:09

Daniel Mahadi


People also ask

Does SSMS have Git integration?

Of course, the good news is that Visual Studio 2015 includes TFS and Git source control integration. With the move to VS 2015 Isolated Shell, SSMS should be able to use these packages as well, right? The answer is… yes…but!

Can Git be used for SQL?

gitSQL is a graphical user interface that connects to your running SQL Server or PostgreSQL database and dumps the content of your database into a file to be stored in Git. The main selling point seems to be cost. It competes with Redgate by being much cheaper and open source. gitSQL works with schema and data.


2 Answers

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/

enter image description here

like image 179
RckLN Avatar answered Sep 25 '22 10:09

RckLN


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:

  1. Download and install ApexSQL Source Control
  2. Start SSMS and in Object explorer select the database you want to be linked to a source control
  3. Right-click the database, and form the context menu, select the Link database to source control option, from the ApexSQL Source Control submenu
  4. 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 Database development model - choose between shared or dedicated
  5. Filter objects which you don’t want to track using source control: by schema, type or name by schema, type or name
  6. Provide appropriate login information and repository string. For Git it is: <protocol>://<hostname>:<portnumber>/<Git server name>/<repository> (see example below): Log into Git source control system

More detailed step-by-step instructions can be found in this article: http://knowledgebase.apexsql.com/link-database-source-control-system-2/

like image 33
Jurgen Muller Avatar answered Sep 22 '22 10:09

Jurgen Muller