SQL History and SQL Archive

This is an overview video of Aqua Data Studio SQL History and SQL Archive feature.

SQL History

The SQL History window is found under the Query main menu, and it’s also an icon on the main toolbar represented here as well. 

So you can launch the SQL history by clicking on this icon on the main toolbar or query SQL history. The SQL History and Archive window is one of the most powerful features within. Aqua Data Studio where you can see a history of any sequel statements that you have executed. 

There are some settings at the top. 

That influences the number of statements that are saved and when they are archived. Here you can see I’ve increased my history to 100 and the max number of statements per entry is 100. That means after I execute my 101st statement, that statement would become archived in the Sequel Archive.

Executing SQL Statements

So let’s execute some SQL statements and Then revisit the SQL History window. 

So if I open up a Query Analyzer and just start typing the Sequel statement, I have some of the Intelligence Fence capabilities. Let me select the table and execute that SQL statement. 

Now if I visit the sequel history. Under Query SQL History, I can see that statement that I just executed. There are a number of other columns displayed as well as the SQL Statement column. 

I can see the date, start and end time, the database platform, even more details on the number of rows selected, the database. Also, what window? Within Aqua Data studio? That sequel statement was executed.

And then there’s also some other settings.

Here within the main toolbar such as the preview SQL that can be very helpful or beneficial. So let’s go back to the Query analyzer and execute another statement or bring in another SQL statement just to see that history start to build. So again I can choose one or multiple tables from some of my pop up windows and then execute one or multiple statements and revisit the sequel history. Okay, so here I can execute an individual SQL statement or multiple sequel statements. Now when we visit the SQL history, I can see that history being built for me.

SQL Archive

So as I mentioned, the number of. SQL statements that are saved and the setting there influences that. The archive allows me to form a history where I can search previous saved sequel statements. So here are my current statements in that numbered setting.

Searching within SQL Archive

If I go to the Sequel Archive, this is a directory that is saving these statements, these Archive statements. So here I have some search capabilities where I could search on, say, a keyword and see any database that had a sequel statement with that keyword. Or I could use, say, a start and end time. And so this really allows you to keep an unlimited history of SQL statements. You can see thousands and thousands of statements have executed over time.

Query Analyzer

So there are other settings here that Allow you to manage this you can select a sequel statement and that would bring that right into the query analyzer for you. So depending on where you left your cursor, you have that capability here. So here I could just select a statement and bring that back into my sequel history. Execute an individual statement here. If I was in, say, some different environments, it has the ability to open up one or multiple SQL statements from SQL history. I could multi, select and bring in multiple statements to my SQL history, or just double click and bring all the statements from a single script into my SQL history. And then there’s other settings that would be helpful for you.

Compare SQL

Here you have the ability to compare two different SQL statements, so that might be helpful for you. Let me select, say, a SQL statement from different environments. And now I have the ability to do a copy, compare and do a side by side comparison of two different SQL statements. So, lots of benefits here in terms. 

Of keeping track of the SQL history, allowing you to preview previously executed sequel, and then the location of these are found in the file options where here I can drill into the general history and see where those are being saved to. So there’s a history folder and then the archive folder, but those are customizable and even shareable if you have other colleagues that need access to the same shared SQL statement directory.

Aqua Data Studio

Thank you for joining this overview video of Aqua Data Studio SQL History and SQL Archive.