Page History
...
Contents
Table of Contents |
---|
...
|
Create an AquaScript
To create an AquaScript
- In the Projects Pane, right-click Projects, and then click New Project.
- Choose a folder to save your project, choose a template to create an AquaScript, provide details for the template.
- 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.