Aqua Data Studio provides Aquascript templates that simplify the use of commonly used AquaScript Open APIs. These templates provide an easy interface to input values and create pre-formatted scripts. The templates are stored in the AquaScript folder with .xjs extension. You can also use these templates for further modification and execution.

Contents

Create an AquaScript

To 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


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.

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


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.

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


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.

 

  • No labels