Best practices to Manage Database project in TFS and visual studio

Question

Currently , we don't have our stored procedures , and everything else related to the proj in TFS , we are managing everything on Server ( Adding , Fixing , removing stored procedured , tables etc) We would like to start manage everything via tfs and visual studio.

Is there any best practices on how to manage this stuff ? I didn't read about Sql Server 2005 Visual studio template and doesn't know what it does , but is there any way to create a project in VS , connect to existing DataBase , and be able to track changes of procedures , in TFS ?

Thanks.

to StackOverflow · Accepted Answer · 2013-05-02 11:11:46Z

5

Yes, you can create a database project and import objects from the database you want to manage. You can start with this MSDN article.

answered May 2, 2013 at 11:11

to StackOverflow

125k34 gold badges212 silver badges345 bronze badges

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

Comments

Ryan Riehle · Accepted Answer · 2013-05-02 13:31:58Z

You can! But I do not recommend the database projects that come with VS 2010 out of the box anymore - they are great, but there is a newer version available. Basically the SQL Server team at Microsoft took ownership of the database project features and has released those features as SQL Server Data Tools (SSDT). This is a free download from the Microsoft site. http://msdn.microsoft.com/en-us/data/tools.aspx

SSDT integrates with either VS 2010 or VS 2012. When you use it to create a database project, it will generate a CREATE script for each object in your database so that you can keep them under version control and compare versions over time. It also has other features like db deployment, unit testing for databases and static code analysis of T-SQL.

I would agree with Ryan. The SSDT database project is the more recent incarnation and there are very few reasons why you shouldn't use these in preference to the older style database projects.

Collectives™ on Stack Overflow

Best practices to Manage Database project in TFS and visual studio

2 Answers 2

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Related