ASA Data Wizard

A GUI utility for SQL Anywhere data management and ASP.NET programming
ASA Data Wizard - From the main window of ASA Data Wizard the user can start importing or exporting database content
  14 Screenshots
ASA Data Wizard is a professional software designed to help you manage your SQL Anywhere data. It provides a number of easy-to-use tools for performing the required data manipulation easily and quickly, such as:
· Data Pump: transfer any schema and data to SQL Anywhere
· Data export to as many as 18 file formats
· Data import from Excel, CSV, text files and more
· ASP.NET Generator: create full set of ASP.NET scripts
· Flexible Task Scheduler
· The Agent application to execute tasks in background mode
· Powerful command-line interface

With all these features ASA Data Wizard will be an everyday assistant in your work with SQL Anywhere database server.

Main features:

  • ASP.NET Generator:
  • ASA Data Wizard provides you with a tool to create ASP.NET scripts for working with SQL Anywhere tables, views and queries. The utility allows you to customize the result HTML appearance and the result script. You can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and more. The result ASP.NET scripts may be protected with password system.
  • Data Pump:
  • Converting any local or remote ADO-compatible database with its structure and data. Full customization of the target database and objects: you can create a new database or convert to the existing one, select objects for conversion and adjust their properties for the target database. Adjustable data import from the source tables to the target ones. The ability of viewing and editing the SQL script generated for the database conversion.
  • Data Export:
  • Data export from SQL Anywhere tables and queries to different databases. The ability to export data to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX and SQL. Selecting fields to be included into the result files. Full customization of the result export files: formats, headers/footers, record count, etc. Powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more.
  • Data Import:
  • Data import into SQL Anywhere tables from different databases. The ability to import data from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV. Easy adjustments of the source file columns and the destination table fields. Full customization of the import process for each imported file including data formats for all or selected fields, commit options, number of rows to skip and records to import, etc. The ability to define the key columns for the table and select whether to skip, update or delete the records if their keys value match the imported ones.
  • Full customization according to your preferences and needs:
  • You can customize the software behavior, select a user interface scheme and set a lot of other preferences.

last updated on:
February 8th, 2014, 19:38 GMT
file size:
7.9 MB
license type:
developed by:
SQL Maestro Group
operating system(s):
Windows All
C: \ Internet \ Servers \ Database Utils
ASA Data Wizard

In a hurry? Add it to your Download Basket!

user rating



Rate it!
14 Screenshots
ASA Data Wizard - By accessing the Task Scheduler tab you can create and manage tasks that will take place automaticallyASA Data Wizard - The Data Pump Wizard enables you to load table structure and data to SQL Anywhere databasesASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data WizardASA Data Wizard
What's New in This Release:
  • DBMS-related features:
  • A possibility of connecting to remote MySQL, PostgreSQL and Firebird databases using keyboard interactive SSH authentication has been implemented. This method provides for a multiple challenge-response dialog with the user in which the server sends a text query to the user, the user types in a response, and this process can repeat any number of times to ensure that the client is a human.
  • The Update Existing Records option has been added to the Data Import module of Oracle Data Wizard. If this option is turned ON, the records will be either updated or inserted. Other servers this feature is available for are: MySQL, PostgreSQL 9.0+, Microsoft SQL Server, SQLite, and Firebird 2.1+.
read full changelog

Add your review!