MS SQL/Oracle Database Projects

Database Project

Modernize your database development lifecycle

Using SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project, without a connection to a server instance. These can all be accomplished by using the table designer, or the Transact-SQL Editor. You can also write and debug Transact-SQL and CLR objects in the same project.

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.

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.

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.