February 17, 2019 at 11:01 am
I was curious to know if we can connect to Git in SQL Server Management Studio without using any third party paid tool like RedGate, Agent SVN, dbForge. An example in Eclipse IDE we can connect to Git using free plugin Egit. Is there something of that sort in SQL Server?
I referred a blog great step by step guide but I cannot see option link database to source control when I right click on my database. I guess that option is only visible after RedGate is installed. (http://www.sqlservercentral.com/blogs/steve_jones/2015/10/05/sql-source-control-and-gitgetting-started/)
Also when I go to Tools->Options -> Search "Source Control" couldn't find anything.
February 17, 2019 at 11:21 am
i do not think there is any other option than a third party tool for that.
see https://dbmstools.com/version-control-tools/sqlserver for some options for SSMS.
Most of the times and if not using one of the paid tools like those from redgate, people will tend to use SSDT with visual studio (shell or paid) and then GIT or SVN as their source repository.
February 18, 2019 at 4:04 am
So, git is a third party tool. We're kind of stuck here. No matter what, something has to interpolate from your database to a git repository. Maybe take a look at Azure Data Studio. It's a lot better than SSMS for source control connections (although, you'll still need a git driver installed). Visual Studio Code can do it, as can SQL Server Data Tools in Visual Studio.
None of these work like the Redgate products though (well, SSDT is pretty good, but not as good). However, fair warning, I work for Redgate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 20, 2019 at 11:12 pm
Thanks, everyone for the input.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply