Icon of program: A5:SQL Mk-2 (64-bit)

A5:SQL Mk-2 (64-bit) for Windows

Download now

Used A5:SQL Mk-2 (64-bit) for Windows?

Editors’ Review

Download.com staff
This robust application provides a comprehensive SQL development environment and ER diagram tool. It offers broad database connectivity, intelligent SQL editing, debugging, and powerful data management features for developers.

  • Pros

    • Direct connectivity to Oracle, PostgreSQL, MySQL, SQLite.
    • Advanced SQL autocompletion handles complex queries.
    • Displays RDBMS SQL execution explain plans.
    • Creates, edits, and reverse-generates ER diagrams.
    • Table editor supports Excel input and output.

  • Cons

    • SQL Explain Plan function supports specific RDBMS only.
    • Advanced stored procedure debugging is specific to Oracle PL/SQL.
Icon of program: A5:SQL Mk-2 (64-bit)

A5:SQL Mk-2 (64-bit) for Windows

Download now

Used A5:SQL Mk-2 (64-bit) for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
2.12.1
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 8
  • Windows 7
  • Windows XP
  • Windows 10
  • Windows Vista
  • Windows 2003
  • Windows Server
Additional Requirements
None
POPULARITY
Total Downloads
3,071
Downloads Last Week
4
Report Software

Program available in other languages

Last Updated

Developer’s Description

By a5m2.mmatsubara.com
Work with an SQL development environment & ER diagram tool.
Connection to various databases: (You can connect directly to Oracle, PostgreSQL, MySQL, SQLite).SQL input completion function: When you press Ctrl+Space, you can parse the SQL statement and complete input of table name and table column name. It is a powerful function to analyze common table expressions and subqueries. Create and edit SQL with GUI: Using the GUI you can create queries using query design and analysis.Show SQL Explain Plan:Displays the explain plan (access plan) when the RDBMS executes SQL.Oracle Database, IBM DB2, SQLServer, MySQL, PostgreSQL only function.Format SQL:Analyze parentheses and subqueries, and indent as necessary.Multiple SQL statements can be processed at once.Continuous execution of SQL delimited by ";" (semicolon) or "/" (slash) or "GO" at the beginning of the line:Only the caret position, after caret position, you can designate the whole and execute SQL continuously.Multiple result sets are output to Excel collectivelyRun SQL twice and compare the resultsYou can run the SQL script twice and compare and display the result set (it is also possible to compare multiple result sets). Comparison result set can be output to Excel. Ability to embed pseudo-instructions that specify column names, result set titles, etc. in query comments:There is a function to specify detailed behavior of the query during query comment.A table editor that can input and output to Excel:You can output the contents of the table (or the result of the query) to Excel. You can also paste from Excel into the table editor. Export and import table contents:You can export and import table contents in CSV format. This CSV format is compatible with Excel. You can also export and import tables in the database in bulk. Ability to insert a large amount of test dummy data:Create dummy data that can be used for load testing.Execute stored procedures: In the case of Oracle PL / SQL, it is possible to pause at break point and reference / change variable contents in debug execution.ER Diagram edit: You can create an ER diagram of the database, output DDL, print / create bitmap. It is also possible to reverse-generate ER diagrams from existing databases.
Download.com
Your review for A5:SQL Mk-2 (64-bit)