Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

What IntelliJ IDEA 2017.3 EAP Brings to Database Tools

DZone's Guide to

What IntelliJ IDEA 2017.3 EAP Brings to Database Tools

The newest EAP version of IntelliJ IDEA comes with a few handy features related to databases, like data source selection when running SQL files and better formatting.

· Database Zone ·
Free Resource

New whitepaper: Database DevOps – 6 Tips for Achieving Continuous Delivery. Discover 6 tips for continuous delivery with Database DevOps in this new whitepaper from Redgate. In 9 pages, it covers version control for databases and configurations, branching and testing, automation, using NuGet packages, and advice for how to start a pioneering Database DevOps project. Also includes further research on the industry-wide state of Database DevOps, how application and database development compare, plus practical steps for bringing DevOps to your database. Read it now free.

We've recently announced the opening of the EAP for IntelliJ IDEA 2017.3, and we have already even looked at some interesting EAP features. However, we didn't cover changes in the database tools yet. So let's explore the major changes in this area.

Selecting Schema When Running a SQL File

IntelliJ IDEA 2017.3 now prompts you to choose database/schema along with a data source when you try to run an SQL file from the tool window:

Jumping to Console From Data Source

For easier navigation, the context menu on a data source in the tool window was upgraded. Choose Jump to Console and you'll now have a handy menu that allows you to quickly switch between your consoles.

Image title


Right-Side Alignment for Numeric Data

For better readability, the IDE aligns the data in the table editor for numerical columns with the right side:

XQuery and XPath Coding Assistance for Microsoft SQL Server

Last but not least, the / support for Microsoft SQL Server is now provided through the Injected Languages feature:

Since the feature has been asked for by some of our users, we backported it to IntelliJ IDEA 2017.2, as well.

To give these new features a try, download the EAP build. And as usual, bug reports along with your feedback are very welcome in our issue tracker.

New whitepaper: Database DevOps – 6 Tips for Achieving Continuous Delivery. Discover 6 tips for continuous delivery with Database DevOps in this new whitepaper from Redgate. In 9 pages, it covers version control for databases and configurations, branching and testing, automation, using NuGet packages, and advice for how to start a pioneering Database DevOps project. Also includes further research on the industry-wide state of Database DevOps, how application and database development compare, plus practical steps for bringing DevOps to your database. Read it now free.

Topics:
intellij idea 2017.3 ,database tools ,xpath ,sql server ,database

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}