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.
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.
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.