A GUI utility for SQL Anywhere data management and ASP.NET programming
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.
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.
- Pentium PC or higher
- 256 MB RAM (512 MB recommended)
- 15 MB of free hard disk space
- SVGA-compatible video adapter
- 30 days trial
- Nag screen
- 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+.
- Other new features:
- [b]Data Import features
- Starting with this version it becomes possible to send an email notification with attached log file after the importing. To enable this feature, you have to provide the email settings (outgoing mail server, login, password, etc…
To Download this Software please Like it on Facebook and more link!
Trackback from your site.