SQL Server Common Tools With Details | Microsoft SQL Server

SQL Server Common Tools With Details

Command Line Tools

PowerShell
Set of libraries to manage SQL Server in PowerShell and deploy SQL Server/SQL Database to Azure.
BCP
Command Line utility to fast load/extract data into SQL Server.
SQLCMD
Command Line mode utility to perform database operations, batch jobs, T-SQL functionality from the command line.
DWLOADER
Command line mode utility to fast load data into Analytical Platform System (APS).

Migration and Upgrade Tools

SQL Server Migration Assistant
Platform migration tool to migrate from Oracle, Sybase, DB2, MySQL, Access to SQL Server or Azure SQL Database. Estimates migration effort, performs schema and data migration.

Microsoft Assessment and Planning Toolkit (MAP)
Agentless discovery of IT resources and asset inventory across the enterprise, including discovery of non-Windows Operating Systems, Oracle Database Instances, SQL Server Instances and databases.

SQL Azure Migration Wizard
Tool designed to help you migrate your SQL Server 2005/2008/2012/2014 databases to Azure SQL Database using bcp. 

SQL Server Data Tools

SSDT Database projects provide an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on- and off-premise) within Visual Studio (IDE). Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries, as well as deployment. Features include schema comparison and deployment testing.

SSDT-BI provides an integrated environment for development of BI solutions within the Microsoft Data Platform. This includes analysis services, data mining, integration services, and reporting projects.

In SQL Server 2016, SSDT is a single, integrated tool running as part of Visual Studio or VS Shell to perform both SSDT database projects and SSDT-BI projects.

SQL Server Management Studio

Tool for configuring, managing, and administering components within Microsoft SQL Server across on-premises and cloud-based deployments of SQL Server as well as SQL Database.

Components include Object Explorer, Data Migration Wizard, Import/Export Data Tier applications, AlwaysOn Availability group administration with Add Replica Wizard, Query Analyzer, Index Tuning Advisor, Activity Monitor, Replication Monitor, and Replication Wizard.