Learn about Microsoft Operations Studio from Microsoft

SQL Operations Studio is a free tool that runs on Windows, macOS and Linux, to manage SQL Server, SQL Azure database and SQL Azure data warehouse or wherever they run. Currently SQL Operations Studio is a preview, but Microsoft has allowed users to download the experience.

Join TipsMake.com to learn about this SQL Server management tool and see how to download and install it on Windows, Mac, Linux.

Transact-SQL code editor (T-SQL) with IntelliSense

SQL Operations Studio (preview) provides a modern T-SQL programming experience focused on the keyboard, making your everyday work easier with built-in features, such as multiple tab windows , rich T-SQL editor, IntelliSense, keyword completion, code, code navigation and source control integration (Git). Run T-SQL queries on demand, view and save results as text, JSON or Excel. Edit data, organize your favorite database connections and browse database objects in a familiar object browsing experience. To learn how to use the T-SQL editor, see the article: How to create a database in MS SQL Server.

The smart T-SQL code

The T-SQL code creates the appropriate T-SQL syntax for creating databases, tables, views, stored procedures, users, login information, roles, etc. and updates the Existing database object. Use smart code to quickly create copies of the database, for development or testing purposes, and to create and execute CREATE and INSERT scripts.

SQL Operations Studio (preview) also provides functionality to create custom T-SQL code. Please refer to the article: Using code to quickly create T-SQL scripts in SQL Operations Studio (preview).

Dashboards for servers and custom databases

Create a rich custom dashboard page to track and quickly fix performance bottlenecks in your database. To learn about utility details and database control panels (and servers), see the article: Managing servers and databases with detailed utilities in SQL Operations Studio ( preview).

Connection management (server group)

Server groups provide a way to organize connection information for servers and databases that you work with. When you create the server group, the configuration details will be saved in the User Settings section.

How to create and edit server groups

1. Click New Server Group at the top of the bar on SERVERS.
2. Enter the group name and choose a color for the group. Adding a description is an optional part.

To edit an existing server group, right-click on the group and select Edit Server Group .

To edit existing server group colors, edit the values ​​in the Server Groups section in User Settings .

Integrated terminal

Use your favorite command line tools (for example, Bash, PowerShell, sqlcmd, bcp and ssh) in the terminal window integrated right into the SQL Operations Studio user interface (preview). To learn about the integrated terminal, see the article: Integrated terminal in SQL Operations Studio (preview).

Download and install SQL Operations Studio (preview)

Microsoft SQL Operations Studio (preview) runs on Windows, macOS and Linux.

SQL Operations Studio (preview) for Windows

This SQL Operations Studio (preview) release includes a standard Windows installer and a .zip file:

Installer

1. Download and run the SQL Operations Studio (preview) installer for Windows.
2. Start the SQL Operations Studio (preview) application.

.Zip file

1. Download the SQL Operations Studio (preview) .zip file for Windows.
2. Browse to the downloaded file and extract it.
3. Run sqlops-windowssqlops.exe.

SQL Operations Studio (preview) for macOS

1. Download SQL Operations Studio (preview) for macOS.
2. To expand the contents of the archive, double-click it.
3. To make SQL Operations Studio (preview) available in Launchpad, drag sqlops.app to the Applications folder .

SQL Operations Studio (preview) for Linux

Download SQL Operations Studio (preview) for Linux using one of the installers or tar.gz archive:

1. .deb
2. .rpm
3. .tar.gz

To extract the file and launch SQL Operations Studio (preview), open a new terminal window and type the following commands:

Debian installation:

 cd ~ 
 sudo dpkg -i ./Downloads/sqlops-linux-.deb 
 sqlops 

Installing rpm:

 cd ~ 
 yum install ./Downloads/sqlops-linux-.rpm 
 sqlops 

Tar.gz installation:

 cd ~ 
 cp ~ / Downloads / sqlops-linux-.tar.gz ~ 
 tar -xvf ~ / sqlops-linux-.tar.gz 
 echo 'export PATH = "$ PATH: ~ / sqlops-linux-x64"' >> ~ / .bashrc 
 source ~ / .bashrc 
 sqlops 

Note : On Debian, Redhat and Ubuntu, you may be missing dependencies. Use the following commands to install these dependencies, depending on your Linux version:

Debian:

 sudo apt-get install libuwind8 

Redhat:

 yum install libXScrnSaver 

Ubuntu:

 sudo apt-get install libxss1 
 sudo apt-get install libgconf-2-4 
 sudo apt-get install libunwind8 

Uninstall SQL Operations Studio (preview)

If you have installed SQL Operations Studio (preview) using the Windows installer, then uninstall it the same way you delete any Windows application.

If you have installed SQL Operations Studio (preview) with another .zip file or compressed file, just delete these files.

Supported operating systems

SQL Operations Studio (preview) runs on Windows, macOS and Linux and is supported on the following platforms:

Windows

1. Windows 10 (64 bit)
2. Windows 8.1 (64 bit)
3. Windows 8 (64 bit)
4. Windows 7 (SP1) (64 bit) - Requires KB2533623
5. Windows Server 2016
6. Windows Server 2012 R2 (64 bit)
7. Windows Server 2012 (64 bit)
8. Windows Server 2008 R2 (64 bit)

Mac operating system

1. macOS 10.13 High Sierra
2. macOS 10.12 Sierra

Linux

1. Red Hat Enterprise Linux 7.4
2. Red Hat Enterprise Linux 7.3
3. SUSE Linux Enterprise Server v12 SP2
4. Ubuntu 16.04

Check for updates

To check for the latest updates, click the gear icon at the bottom left of the window and click Check for Updates .

See more:

1. Activate foreign keys in SQL Server
2. Disable foreign key in SQL Server
3. Delete the foreign key in SQL Server