Microsoft SQL Server Management Studio (SSMS) is a software application developed by
Microsoft
Microsoft Corporation is an American multinational corporation and technology company, technology conglomerate headquartered in Redmond, Washington. Founded in 1975, the company became influential in the History of personal computers#The ear ...
that is used for configuring, managing, and administering all components within
Microsoft SQL Server
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it is a software product with the primary function of ...
. First launched with Microsoft SQL Server 2005, it is the successor to the Enterprise Manager in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.
A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server. It also shipped a separate Express edition that could be freely downloaded; however recent versions of SSMS are fully capable of connecting to and manage any SQL Server Express instance. Microsoft also incorporated backwards compatibility for older versions of SQL Server thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately.
Starting from version 11, the application was based on the
Visual Studio 2010 shell, using
WPF for the user interface. Versions 18 and after are based on the
Visual Studio 2017
Visual Studio is an integrated development environment (IDE) developed by Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms ...
Isolated Shell.
In June 2015, Microsoft announced their intention to release future versions of SSMS independently of SQL Server database engine releases.
See also
*
Comparison of database administration tools
*
SQL Server Management Objects
References
External links
SQL Server Management Studio (SSMS)
Microsoft database software
Database administration tools
{{Microsoft-software-stub