Datagrip logo

The DataGrip Blog

The Cross-Platform IDE for Databases & SQL
Download
Uncategorized

DataGrip 2020.1.5

Maksim Sobolevskiy
Maksim Sobolevskiy

Introducing DataGrip 2020.1.5! Check out what’s new inside!

Most important

The issue with SQL Server Authentication on Windows is fixed.

Other fixes

DBE-9876: Forced execution in read-only mode now runs the correct query.
DBE-10727: Schemas comparator respects column order.
DBE-10715: [PostgreSQL]: DataGrip no longer throws a time zone error for versions of PostgreSQL before 10.
DBE-10724: [Snowflake]: The Modify Table dialog generates valid code.

New features

A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted.

Screenshot 2020-06-25 at 15.35.21

We have also renamed the migration buttons in the schema comparator to make it clearer what they actually do.

Screenshot 2020-06-25 at 15.35.26

If you create a DDL data source, the folder with the sources will automatically be attached to the project.

Screenshot 2020-06-25 at 15.35.29

If you try to change the DDL of the target table during the data import process, DataGrip will double-check this with you with an alert box to confirm that you want to perform this action.

Screenshot 2020-06-25 at 15.35.35

If an Oracle database wants you to change an expired password, you can do so from the DataGrip UI. This works for versions from Oracle 12.2 if you use the standard JDBC driver. If you use the OCI driver, it works for the older versions as well.

Screenshot 2020-06-25 at 15.35.39

DataGrip 2020.2 EAP 2DataGrip 2020.2 EAP 3
Comments below can no longer be edited.

5 Responses to DataGrip 2020.1.5

  1. Avatar

    Jógvan Olsen says:

    June 25, 2020

    Would it be possible to get information about what was the reason for the “SQL Server Authentication” bug?

    • Avatar

      Maksim Sobolevskiy says:

      June 26, 2020

      It was a super-internal reason with our old code not being compatible with the new JetBrains Java Runtime version.

  2. Avatar

    John says:

    June 25, 2020

    Will there be an implementation for Azure DB MFA? As right now I can not connect to these DB’s, I have to use SSMS.

  3. Avatar

    Telmo says:

    June 26, 2020

    After this update, DataGrip wont open. I have restarted and I’v tried to locate logs but cant find any logs under C:\Users\«myUserName»\AppData\Roaming\JetBrains\IdeaIC2020.1

    Any idea?

Discover more

Introducing MongoDB Shell in DataGrip

Hi! We've released the new version of the MongoDB JDBC driver, which means that DataGrip now includes support for the new MongoDB Shell out of the box. This is the result of a close collaboration between engineering teams at MongoDB and JetBrains, and we are excited to finally release it to all our users. If you use DataGrip to work with MongoDB and Atlas, you get a console/shell experience that

Maksim Sobolevskiy Maksim Sobolevskiy

DataGrip 2020.2 EAP Has Started!

Hello, everybody! You may be keen to know what we are planning to include in this summer’s release. We’ve got a description here of what you can already try. A new UI for boolean values Well, this is quite a welcome development! There’s a new way to observe and edit boolean values that is more user-friendly. Editing: – The space key toggles values like it used to. – Typing f, t, d, n, g

Maksim Sobolevskiy Maksim Sobolevskiy

Workaround for SQL Server Authentication Issue on Windows

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

Maksim Sobolevskiy Maksim Sobolevskiy

DataGrip 2020.1.4

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.

Maksim Sobolevskiy Maksim Sobolevskiy