Skip to content

overview-sql-tools.md

Latest commit

 

History

History
33 lines (29 loc) · 2.3 KB

overview-sql-tools.md

File metadata and controls

33 lines (29 loc) · 2.3 KB
title Overview of SQL Server Tools | Microsoft Docs
ms.custom
ms.date 07/21/2017
ms.prod sql-server-2017
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
ms.assetid
caps.latest.revision 0
author stevestein
ms.author sstein
manager craigg

Overview of SQL Server Tools and Utilities

[!INCLUDEtsql-appliesto-ss2008-all_md]

This article provides a list of the tools and utilities that are available to help you develop and manage SQL Server, Azure SQL Database, SQL data warehouse, SQL Server-based applications.

Tool Description
SQL Server Management Studio (SSMS) Use SQL Server Management Studio (SSMS) to query, design, and manage your SQL Server, Azure SQL Database and Azure SQL Data Warehouse.
SQL Server Data Tools (SSDT) Turn Visual Studio into a powerful development environment for SQL Server, Azure SQL Database and Azure SQL Data Warehouse.
Configuration Manager Use SQL Server Configuration Manager to configure SQL Server services and configure network connectivity.
SQL Server Migration Assistant Use SQL Server Migration Assistant to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle and Sybase.
Distributed Replay Use the Distributed Replay feature to help you assess the impact of future SQL Server upgrades. Also use Distributed Replay to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
ssbdiagnose The ssbdiagnose utility reports issues in Service Broker conversations or the configuration of Service Broker services.
Command Prompt Utilities Command prompt utilities enable you to script SQL Server operations. This article contains a list of command prompt utilities that ship with SQL Server.