Contents

• Create an AquaScript
• Create and Email Excel File
• Database Schema and Data Exporter
• File Transfer and Remote Command Execution
• Multi Server Script Execute
• Random Table and Data Generation
• Schema Compare

Create an AquaScript

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

Create and Email Excel File

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

Database Schema and Data Exporter

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. 

Multi Server Script Execute

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.

Schema Compare