SQL Server Data Tools | Visual Studio - Visual Studio Skip to content
SQL Server Data Tools | Visual Studio2020-08-28T11:50:50-07:00

SQL Server Data Tools for Visual Studio

Turn Visual Studio into a powerful development environment for SQL Server, Azure SQL Database and Azure SQL Data Warehouse.

SQL Server Data Tools screenshot

Database Project

Modernize your database development lifecycle

Develop, build, test and publish your database from a source controlled project, just like you develop your application code. Start from scratch with a new Database project, or import an existing database with a few clicks

IntelliSense and Editing

Validate T-SQL scripts as you type

Editing T-SQL in your database is easier thanks to enhanced IntelliSense and error highlighting. Identify syntax and schema reference errors, track the impact of your changes using Find All Reference and Go To Definition. By the time you finish typing, your T-SQL script is already tested and ready to run.

Intellisense screenshot
Table Designer screenshot

Design Tables

Focus on what your table should be. Forget how to get there.

Use Table Designer to design a new table, modify existing table, or quickly add new or modify existing columns, constraints and indexes. You don’t need to write the complex code to alter affected indexes, views, procedures and functions – Visual Studio writes the change script for you. Just focus on what your table should be.

View and Edit Data

View and edit data without writing a script

Viewing and editing data in a table is the most frequent task for developers but it usually requires writing a query. With Visual Studio, view and edit data in a tabular grid, filter the grid using a simple UI and save changes to your database with just a few clicks.

screenshot of table for viewing and editing
Schema Compare screenshot

Schema and Data Compare

Diff your database

Do you ‘diff’ to know changes in your application’s source code? You can do diff on multiple versions of your database using schema compare and data compare in Visual Studio. The result of the comparison between two databases or database projects is analyzed and allows you to apply the change from source database to target, or simply generate T-SQL scripts you can view, modify and run at your control.

Continuous Integration and Deployment

Essentials for success

Continuous integration and continuous deployment has become a common practice for modern application development projects. Use Visual Studio to bring databases into your end-to-end application development lifecycle (ALM) practice by fully automating build and deployment whenever a change is made to your application and database. Invest 10 minutes to significantly boost the chance of success for your project.

database cicd screenshot

Free, fully-featured IDE for students, open-source and individual

Free download

Professional developer tools, services, and subscription benefits for small

Free trial

End-to-end solution to meet demanding quality and scale needs of teams of all

Free trial