SQL Server

Hello! We've got something new for you in this fresh EAP build. Azure AD authentication The DataGrip community has been asking for this for a while! You can now use Azure AD to log in to your database. Collect introspection diagnostic information Introspection is the process by which DataGrip retrieves information about a database. This information is used to show the objects in the database explorer, display their DDLs, suggest them during completion, and so on. Sometimes introspection runs into problems. Now, when things go wrong, you can collect useful data that you can pass on to our su

For those of you who are eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2020.3. As you may know, these builds don’t require a license – we just want everybody to try the new features out before the official release. Let’s go! Couchbase support We're always happy to welcome a new database into our family, and our newest member is Couchbase! It's important to mention that DataGrip supports the Couchbase Query service, not the Couchbase Analytics service. Introspection Grants The most important enhancement in this aspect is that DataGrip now knows ab

Important fixes: DBE-11340: The username and password fields no longer disappear. DBE-11156: When updating the source code, if a new version contains errors and fails to be submitted, you'll now see a prompt to restore the previous version.

Hello! Please welcome the newest build of our DataGrip 2020.2 EAP. Separate editor for cell values Now if you have a huge value in your cell, it can be viewed or edited in a separate panel. You can also toggle soft wrap mode using the right-hand toolbar. DML preview in the data editor Starting with this version, you can review the query that represents your changes in the data editor. This query is not the exact SQL that will be run to modify your data, because DataGrip uses a JDBC driver to update tables, but most of the time it will be the same. So, now you have There is now a DML bu

In DataGrip 2020.1.4 for Windows there is a problem with SQL Server authentication. We are currently addressing this issue and we expect it to be resolved in 2020.1.5. There are two workarounds to fix the problem: Downgrade to 2020.1.3 or switch to a different version of JetBrains runtime.   Downgrading to 2020.1.3 If you use the ToolBox application, you can downgrade directly from it. If you manually installed DataGrip, download the previous version here. Switching to a different version of JetBrains Runtime This workaround is more complicated but suits those who need to use the la

Introducing DataGrip 2020.1.4 NB! KNOWN ISSUE! This update breaks the Windows authentication to SQL Server. This problem will be fixed in 2020.1.5, the workarounds are described here. Fixes: DBE-7578: DataGrip no longer refreshes the database after running a query in read-only mode. DBE-9417: Targets in the Run Configuration dialog are now filtered by dialect.

Hello! It’s time to start our EAP for 2020.1. As usual, you don’t need to have a subscription to use them, and regardless of whether you have a subscription or not, we would still truly appreciate your participation. Your feedback will help us ensure that what we release this April is of the highest quality! So, let’s take a look at what’s featured in the EAP! Run configurations This concept is already in use in our other IDEs, and it’s now come to DataGrip. In general, if you want to run something, you just need to create a configuration for it. Let’s look at how this can help you with parti

Hi! This is the third update for DataGrip 2019.1. First, there are no more freezes after sleep! https://youtrack.jetbrains.com/issue/IDEA-210361 Also, we’ve fixed the annoying indentation in SQL Server that was happening after starting a new line. Other fixes: IDEA-176926 The All Places scope now includes scratch files and consoles. This is more important for anyone using the database plugin in other IDEs, and not DataGrip itself. In DataGrip scratches and consoles were already part of the All Places scope. DBE-7993 The Formatter keeps the line break before INTO. DBE-8223 The Formatter doesn

Hello!  From this post you'll find out what's new in DataGrip 2017.1. It is a long read, so let's begin with the table of contents. Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid. Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database. Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option;  Settings for Qualifying objects and more. Database objects: Double-cliсk ope