Getting Started with Database Features in Visual Studio
You can use Visual Studio to help manage the development life cycle of your databases as an important part of your application development. You can use Visual Studio to implement the concept of an isolated development environment for each database professional. Team members can work on schema-related activities without interfering with other team members or putting the production environment at risk. By managing database change, you can provide better communication and closer coordination among developers of software and databases.
In the following table, you can find descriptions of common tasks that support this scenario and links to more information about how you can successfully complete those tasks. In addition, you should determine how these tasks best fit with the development methods of your team.
Learn how you can manage changes to your database by using Visual Studio: You can learn how to use Visual Studio to manage your databases and servers as an integrated part of your overall application development. You can also learn how Visual Studio integrates with Team Foundation Server.
Learn which SQL Server permissions you need: The specific permissions that you need vary based on what action you want to perform in Visual Studio. For example, you need specific permissions to import objects and settings from a database or to deploy updates, but not to create or modify a database project.
Get hands-on experience: You can complete a series of introductory walkthroughs to learn how you can use Visual Studio in your application life cycle. These walkthroughs introduce you to the practices of offline database development, establishing a quality baseline, and performing iterative database development tasks.
Perform common tasks: As you use Visual Studio, you will frequently open a database or server project and specify the information that is required to connect to a database.
Troubleshooting: You can find information about how to identify and resolve problems that you might encounter when you manage changes to a database or a database server.