Preview Content - log in or Buy Access Pass

how to create database project in visual studio 2010

Author(s): by Katie Glownia & by Emil Glownia

In this step by step tutorial I will show you how to create database project in Visual Studio 2010. For the purpose of this tutorial I will use  Visual Studio 2010.

Let's start with explaning why you would want to create a SQL Server database project. Visual Studio has a template that allows you to store information about SQL Server objects in a centralized place and under TFS (version control) that allows you to build your database project in a controlled environment that is easy to share with other developers but the project allows much more than that. You can use to easily deploy changes to a server and it will perform schema comparison (based on settings you chose) which saves a lot of time when you want to prepare release scripts manually. Additionaly you use can use the database project to enforce certain company standards. There might be certain standards you cannot enforce but you can deploy the project to dev environment and use SQL Server policy-based management to ensure you comply with standards (for instance stored procedures start with usp_ and not system stored procedures sp_)

How to create database project

In Microsoft Visual Studio 2010 I select New Project option. See screenshot below (You can also use the menu).

To access members only content...
Log in (active member) or buy Access Pass
Learn as much as you like
Unlimited learning access pass*
* Secure one off payment, no re-occuring payments, no surprises
T-SQL SSIS SSRS 79 Mini Courses 529 Pages 287 Videos 314 Articles
Forum Live Webinars 12 Webinar Recordings DIY Projects Progress Tracking
New member joins every 8 hours
   

60 days, 100% money back guarantee
NO risks, NO questions asked, NO hard feelings

I can't speak highly enough of the quality MSBI materials industry practitioners with varying level of experience and exposure can benefit from this website. Their structured learning plan and courses, DIY projects, webinars and relevant resources go a very long way. I've gained a whole new perspective on delivering client BI projects to highest standards by employing best practices recommended on this website. Best quality MSBI training online suite I have used and least expensive too.

Franklin Demilade Osinowo

Best and affordable BI Training platform in the web. KEBI Academy doesn't provide training on BI rather their approach is to make you learn BI by yourself. Self Learning is always the best approach and I recommend KEBI Academy.

Jaiyaram Mahendran


You both are doing a great job by sharing your knowledge and experience, it helps many people who want to learn MSBI from the starting point and also for an experienced person to get to know more about MSBI. Thank you and keep sharing your MSBI knowledge and experience.

Shweta Patel

Great work on the videos. I have been enjoying them.

Patt Nelson


Did you find this page useful?
+2  |  -0
(2 Votes)