...

Contents

Create an AquaScript

To create an AquaScript

1. In the Projects Pane, right-click Projects, and then click New Project.
   Image RemovedImage Added
2. Choose a folder to save your project, choose a template to create an AquaScript, provide details for the template.
   Image RemovedImage Added
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.
Image RemovedImage Added

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 RemovedImage Added

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 RemovedImage Added

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 RemovedImage Added

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 RemovedImage Added

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 RemovedImage Added