|
|
|
| Downloads: 2,258 |
 Tell us about an update
|
 |
|
User Rating:
Rated by: |
NOT RATED
0 user(s) |
|
|
|
ASA Data Wizard description
|
A GUI utility for SQL Anywhere data management and ASP.NET programming
ASA Data Wizard is a professional and high quality pieace of software designed to help you manage your Sybase SQL Anywhere data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly:
· 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 our software will be an everyday assistant in your work with SQL Anywhere database server. Here are some key features of "ASA Data Wizard":
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.
Requirements:
· Pentium 166 MHz
· 64 MB RAM
· 10 MB HDD
· SVGA
Limitations:
· 30 days trial
· Nag screen What's New in This Release: [ read full changelog ]
Data Import features:
Starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
· To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).
· This type of data import does not require the structure of source database to be identical with the structure of the target one. For example, data from a single source table can be imported to several different target tables and vice versa. This becomes possible because of an ability of using custom SQL queries as import data sources. Other benefits of this feature include restr...
|
|
 | | Softpedia guarantees that ASA Data Wizard 11.1.0.1 is 100% CLEAN, which means it does not contain any form of malware, including spyware, viruses, trojans and backdoors. [read more >] |
|
Find us on Google+
