Welcome to this first of three blog posts that would cover the basics of getting practical usage of Aqua Data Studio's FluidShell.
Introduction: What is FluidShell?
FluidShell includes commands which can be executed from the shell's command line. The commands provide a variety of functionality which are common to Unix shells and/or SQL shells. FluidShell includes a large number of commands for a shell terminal, database access, data manipulation, filesystem navigation, file and data archiving, network operations, and general utilities.
In this first session, we will be covering how to execute a simple SQL statement via the interface and will gradually progress to executing commands from a file.
Initializing the FluidShell environment
Right click on any database server platform of your choice; in our case, we are choosing Microsoft SQL Server, and then select FluidShell from the menu.
You should be seeing a screen similar to this below:
Now the plug icon, if enabled, showcases that we can connected to the database in question; here we are seeing the Northwind database.
Steps to execute a SQL command
We will now, run a command to query the products table:
Select TOP 10 * from Products <Press Enter>
GO
This will deliver the results shown below:
Congratulations! You have just executed a SQL Statement in FluidShell!
In the next section, we will be covering System Level and Export options to CSV and JSON.
Until next time, happy querying with FluidShell using Aqua Data Studio!