With RubyMine, you can query and modify configured data sources from the
dedicated Database Console tool window
using one of the supported languages:
- SQL Server
You can either enter all the necessary commands in the Input pane of the
console or prepare a file that contains commands
in the desired language. In both cases, RubyMine provides code specific completion, syntax and error
highlighting, and completion
of the data source, table and column names.
RubyMine also supports operations with database binary
large objects (BLOBs).
The Input pane opens as a new editor tab as soon as the Database
console is invoked.
Retrieved records are shown in the Result pane, where you can view, analyze,
and update them.
RubyMine opens connections to databases when necessary without any steps from your side and
displays them below corresponding data source nodes in the Database tool
The SQL server should be running. You can create a special command using the external tools
configuration facility, as described in the section Using
In this section: