SQL Server Data Tools
E57248
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
Visual Studio extension
→
database development tool → integrated development environment component → |
| developedBy |
Microsoft
→
|
| distributionModel |
downloadable Visual Studio extension
→
included with Visual Studio → |
| license |
proprietary software
→
|
| operatingSystem |
Windows
→
|
| partOf |
Microsoft Visual Studio
→
|
| replaced |
Business Intelligence Development Studio
→
|
| softwareGenre |
business intelligence development tool
→
database IDE → |
| supportsDatabaseManagementSystem |
Azure SQL Database
→
Azure SQL Managed Instance → Microsoft SQL Server → SQL Server on Azure Virtual Machines → |
| supportsFeature |
IntelliSense for T-SQL
→
SQLCMD variable support → SSAS project development → SSIS package development → SSRS report development → T-SQL debugging → T-SQL editing → code navigation for database objects → continuous integration for database projects → data comparison → data-tier application (DAC) packaging → database code analysis → database deployment → database project system → database refactoring → database snapshots → database unit testing → post-deployment scripts → pre-deployment scripts → schema comparison → schema validation → source control integration → stored procedure designer → table designer → view designer → |
| usedFor |
debugging Azure SQL databases
→
debugging SQL Server databases → deploying Azure SQL databases → deploying SQL Server databases → designing Azure SQL databases → designing SQL Server databases → developing Azure SQL databases → developing SQL Server databases → developing business intelligence solutions → |
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
SQL Server
→
|
hasComponent |
|
SQL Server Integration Services
→
|
usesIDE |