DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
What's in store for DevOps in 2023? Hear from the experts in our "DZone 2023 Preview: DevOps Edition" on Fri, Jan 27!
Save your seat
  1. DZone
  2. Data Engineering
  3. Databases
  4. Create a Database Project in Visual Studio

Create a Database Project in Visual Studio

Michael Georgiou user avatar by
Michael Georgiou
·
Feb. 06, 13 · Interview
Like (0)
Save
Tweet
Share
19.38K Views

Join the DZone community and get the full member experience.

Join For Free

Introduction: All software development involves databases. It is very difficult to manage and maintain databases when multiple developers are working on it. Visual studio provides a feature where we can create a database project, where it makes easier to maintain databases.

Below are the steps to create database project in visual studio 2010.

1.  Open Visual Studio 2010. Click on File -> New -> Project

2.  Select database -> SQL server and choose SQL Server 2008 Database Project.

3.  Database project will get created.

4.  Now we are ready to compare database project with actual database in SQL server

Click on Data -> Schema Compare -> New Schema Comparison

Source schema is a database/project used to update target database/schema.

5.  Schema Comparison can be done using 4 different types.

a.  SQL Database to VS database project

Select Source Schema as a Database and Target Schema as a Project.

b.  VS database project to SQL database

Select Source Schema as a project and Target Schema as a Database.

c.  SQL database to SQL database

Select Source Schema and Target Schema as a Database.

d.  VS database project to VS database project

Select Source Schema and Target Schema as a Project.

6.  Here is detailed comparison for SQL Database to VS database project

Select database and project and click OK.

Next window will appear.

We will need to use following buttons from toolbar.

7.  Click on filter icon and select Non Skip Objects.


8.  Click on Refresh Update Script.

9.  Then click on Write Updates. Finally click on Refresh icon.

This will update SQL Database to VS database Project.

Conclusion: Visual Studio database project helps developer to manage and maintain database easily. It also makes easier to update databases on the server. 

This article was written by the Imaginovation team.  They are a Raleigh web design and software development company who uses .NET, PHP, HTML5, JavaScript, and jQuery technologies.

This article was written by the Imaginovation team.  They are a Raleigh web design and software development company who uses .NET, PHP, HTML5, JavaScript, and jQuery technologies.

Database Software development Schema sql

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • The ChatGPT Model: A Real-Life Example
  • Leaders Make Their Own Problems
  • Integration: Data, Security, Challenges, and Best Solutions
  • Exploring the Benefits of Cloud Computing: From IaaS, PaaS, SaaS to Google Cloud, AWS, and Microsoft

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: