Transition from SSMS to DataGrip: 10 tips
This post is for people familiar with SQL Server Management Studio who have decided to try DataGrip with SQL Server. Some concepts, pieces of the user interface, and shortcuts differ between these two tools. We'd like to try and help you with this transition! TLDR: table SSMSDataGripConnects to any running serverTCP/IP and SQL Server Browser should be enabledAll databases and schemas are sho
DataGrip 2020.3 EAP 2
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 exp
DataGrip 2020.3 EAP is Started!
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 importan
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.
DataGrip 2020.2 EAP 2
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
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 it.
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.
We open EAP for DataGrip 2020.1
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 a
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
Top 9 SQL Features of DataGrip You Have to Know
DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP One of the most important activities for anyone working with databases is writing SQL. Built on IntelliJ Platform, DataGrip makes coding an enjoyable experience by automating repetitive tasks: as an SQL developer, you probably h
DataGrip 2017.1 Released!
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: Res
Connecting DataGrip to SQL Server Express LocalDB
UPDATED: September, 2019 Check the LocalDB instance You can easily connect to your LocalDB instance with DataGrip. And as a first step, check if your LocalDB instance is ready for a connection. Locate SqllocalDB.exe and run the SqllocalDB.exe i command in a terminal. You will see a list of available LocalDB instances on the server. To create an instance, run SqlLocalDB