DataGrip – a powerful MS SQL Server GUI tool for Windows, macOS and Linux.
JetBrains DataGrip is a cross-platform IDE for SQL with first-class support for Microsoft SQL Server and other databases and DDl sources.
DataGrip provides accurate syntax highlighting and supports all the important types of objects in your MS SQL Server database.
DataGrip provides various benefits to Microsoft SQL Server developers. It provides you with smart coding assistance and code completion, detects probable bugs in your code and suggests the best options to fix them.
Coding is what most developers spend the bulk of their time doing in an IDE. DataGrip’s smart features like auto-completion, code snippets, formatter, refactorings, and various intention actions help you code faster. Concentrate on the logic, not on what you need to type!
DataGrip provides a smart data editor with the ability to add, delete, and change data. All of the queries DataGrip runs during data updates can later be found in its SQL log so you can perform the same changes against another database.
DataGrip’s data extractor supports many formats including SQL INSERTS, SQL UPDATES, CSV, JSON, XML, and others. The mechanism is customizable so you can create your own formats, such as Markdown or just plaintext.
If you work with SQL files stored on your computer, then you might already have a working directory with tons of scripts. DataGrip provides a handy interface for that. Attach folders from your computer, associate them with data sources, run scripts against several databases, or even use built-in Git integration!
The DataGrip interface can be customized in many ways. You can choose from any of the default color schemes or create your own, mark data sources with different colors, and even customize or set up your own keyboard scheme.
DataGrip displays Linked Servers in the Database Explorer. You can map your linked server in an SQL Server to any existing data source so that code completion and resolution will work for queries using those external objects.
tSQLt is a framework for unit testing on Microsoft SQL Server. You can use it to test stored procedures, functions, views, and triggers for a database.
After installation, the tSQLt script creates the tSQLt schema, from which you can run one or more tests and explore the results.
SQL Server LocalDB has its own dedicated data source type for LocalDB. You only need to set the path for the executable once, in the driver options, and it will be applied for all data sources.
DataGrip uses a JDBC driver to connect to your MS SQL Server database, which will be downloaded automatically when testing the connection. In addition to the main credentials you’ll need in order to connect (such as port, user, and password), you can set several options for the new MS SQL Server data source:
Once you’re connected to your MS SQL Server database, you’ll see the list of objects in the left-hand pane, called the Database Explorer. Here you can filter objects and choose which schemas should be shown.
DataGrip can help you detect bugs and problems that are likely to arise in your SQL code before you compile and run it. Here are just a few examples of DataGrip coming to the rescue by catching mistakes and bringing them to your attention.