Page History

...

1. In the Projects Pane, right-click Projects, and then click New Project.
   Image Modified
2. Choose a folder to save your project, choose a template to create an AquaScript, provide details for the template.
   Image Modified
3. Click Create.

...

Generates an AquaScript that creates an Excel file from a user-specified SQL query and emails the Excel file to the specified recipients.
Image Modified

Database Schema and Data Exporter

Generates an AquaScript that extracts the DDLs of all database objects for the chosen database/schema to the user-specified directory. In addition, all table data is exported in CSV, XML, or XLS file format. Optionally, the generated files can be archived to ZIP, TAR or TGZ format.
Image Modified

File Transfer and Remote Command Execution

Generates AquaScripts that transfer files from/to a remote system by using File Transfer Protocol (FTP), Secure Copy Protocol (SCP) or Secure File Transfer Protocol (SFTP). Executing commands on a remote server via SSH is also supported. 
Image Modified

Multi Server Script Execute

Generates an AquaScript that reads all the SQL scripts in the User Files folder and executes them against each connection specified in the Servers folder.

Image Modified

Random Table and Data Generation

Generates an AquaScript that creates DDLs for a varying number of tables, columns and data types for the chosen database server and writes the DDLs to a file. Generates a separate AquaScript that executes the contents of the generated file. Generates a third AquaScript that populate tables with random data based on the column's data type.
Image Modified

Schema Compare

Generates an AquaScript to compare the source and the target schemas and writes the differences to an HTML file or the Aqua Data Studio Console tab.
Image Modified