How to Connect to Microsoft SQL Server in IntelliJ IDEA

Through this video, I'd like to share with you how to connect and manage a database on Microsoft SQL Server right inside IntelliJ IDEA using the built-in Database tool provided by IntelliJ IDEA. So you don't have to use any external tools, especially in case you need to manage a database on a remote instance of SQL server without having to install SQL server client tools on your computer.

In details, you will learn:
- Make connection to SQL Server in IntelliJ IDEA
- Create a new table
- Manage data in a table
- Execute SQL statements

Software programs:
- Java Development Kit (JDK)
- IntelliJ IDEA Ultimate
- Microsoft SQL Server 2019 (Express edition)

[khacthinh.]

Video của bạn hướng dẫn rất chi tiết, tôi đã biết thêm rất nhiều, Cảm ơn bạn rất nhiều

[blamepotato]

Hello, my data source has multiple databases and it seems I can only introspect one of the databases but not all of them. Do you how to fix it?

[mehdibouhamidi]

i'm using IntelliJ IDEA 2020.3.1 (Community Edition) and i didn't find DATABASE menu is there any solution for community Edition ? i want to use SQL SERVER with my JAVA project, and i want some help please.

[Alabedy]

bro intelliJ doesn't have the database option anymore shouls I switch back to 2020.1.1 ?

[jafh]

How would I connect a JavaFX application to a local SQL server management studio database? I'm kinda new to this and I'm probably not making the actual database right. Do you have any tutorials for setting up and creating the SQL server management studio database correctly then connecting it to a Javafx application locally?

[sandarujayathilaka]

Hello sir
What should we type in host
And after testing i got a error called The server sqlexpress is not configured to listen with TCP/IP ?

[gooidoekoe]

so unsecure, why would you use windows 7 in 2020...