2

I have been looking for solutions to providing source control for my SQL Server 2012 instance. I have looked at Red-Gate's solution but it is outside my price range. Since I already make use of Visual Studio Online (VSO) source control for my .NET projects I was wondering if it was able to provide source control for SQL Server?

I have seen articles (listed below) that discuss using Team Foundation Server (TFS) for source control however I do not have a dedicated TFS server, just VSO.

Improve this question
3
  • I don't think there is any problem for using VSO for your situation Commented Sep 3, 2014 at 15:01
  • How would you use VSO to manage version control? Commented Sep 3, 2014 at 15:43
  • Checkout the second comment on the first article you posted. Commented Sep 3, 2014 at 19:43

2 Answers 2

Reset to default
6

I would definitely recommend using Visual Studio Online or Team Foundation Server to hold your database scheme in version control. There is a fairly recent article in Visual Studio Magazine that discusses using the SQL Server Data Tools (SSDT) to be able to make that easier for you: Simplifying Development with Visual Studio Database Projects. SSDT is available for any version of Visual Studio including the Community and Express editions.

SQL Server Data Tools

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Redgate was out of my price range too unfortunately...

The SSDT tools for VS are amazing, and i recently started using it for comparing DB versions - and then generating change scripts. Here's a start point if you want to get into that...

Other Free Alternatives?

  1. Liquibase
  2. gitSQL

Liquibase - i couldn't get my head around but if you can get it working, it may be better for other databases, if you have the requirement to use other databases.

I use gitSQL - it's free up to 20 tables... If you have more than 20 tables then it costs $40 - which is still so much cheaper than the redgate solution.

gitSQL are also setting up command line options in a future release, so potentially you could run it via a batch file, and set up continuous integration.

gitSQL are also talking about postgres, mysql editions in the future.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.