Advertisement
Overview
A5:SQL Mk-2 is a free SQL development environment & ER diagram development tool developed to support database development that is complicated.
Features
Connection to various databases (You can connect directly to Oracle, PostgreSQL, MySQL, SQLite)SQL input completion function (also analyzes common table expressions and subqueries)Create and edit SQL with GUIShow SQL Execution plan Format SQLContinuous execution of SQL delimited by ";" (semicolon) or "/" (slash) or "GO" at the beginning of the lineMultiple result sets are output to Excel collectivelyExecute SQL twice to output differences to Excel (also possible to compare multiple result sets)Execution of SQL with parametersFiltering of tables and query result sets (narrowing down)Directive specifying a column name, a result set title, etc. in a query comment Function to embed decreeTable editor that can be output to ExcelDisplay property of table (additional RDBMS information)Show table sourceExport/Import of table contentsInsert a large amount of test dummy data into the tableCreate ER diagramCreate ER diagram from databaseCreate DDL of database from ER diagram
What's new
- Fixed the problem that the logical name of ER diagram can not be acquired well when assigning ER diagram to the database.
- Fixed the problem that surrogate pairs can not be handled correctly when encoding is UTF8MB4 in MySQL.
- Fixed the bug that NULL was replaced by \'\' in the data transfer function between schemas from version 2.14.0.
- Fixed the bug that NULL was replaced by \'\' in dummy data creation function from version 2.14.0.
- Fixed the bug that the character representing the tab of the text editor is garbled when used in English mode
- Fixed the problem that the focus moves to the completion window when resizing the completion window with the mouse in the SQL editor.
- Improved decision logic to switch to stored procedure mode in SQL editor
- Improved to open DB connection dialog when there is no DB connection when opening table name at caret position in table editor with SQL editor
- Fixed the problem that an error occurs when you comment on the filter in SQL editor and table editor
- Improved not to remove SQL delimited semicolon when executing MERGE statement in Microsoft SQL Server
- Changed so that updates can not be made when a table without primary key / unique index / unique constraint is opened in the table editor
- Fixed the problem that a row could not be registered without specifying a value for a column with NOT NULL and default value in the table editor.
- ... Fix other problems
Additional Information
- Developed by masakazu matsubara
- Version 2025.02.16
-
Requires
Available on: PC
OS: Windows 10 version 17763.0 or higher
Keyboard: Not specified
Mouse: Not specified
- Published 2019-03-25
- Size 22.39 MB
- File Type appx/msix
-
Language
English (United States)
-
Permissions
Uses all system resources
- Microsoft Store ID 9nsbb9xtjw86
Advertisement
How to download and install A5:SQL Mk-2 (x64) from the Microsoft
Method 1: Download and Install via the Microsoft Store
This is the most straightforward and secure way to get A5:SQL Mk-2 (x64).Step 1: Open the Microsoft Store
Step 2: Search for A5:SQL Mk-2 (x64)
Step 3: Download and Install
Step 4: Access the App
Method 2: Download from the Official Microsoft Website
If you prefer downloading directly from the web, you can use the official Microsoft website.Step 1: Visit the A5:SQL Mk-2 (x64) Page
Step 2: Download the App
Step 3: Install A5:SQL Mk-2 (x64)
Step 4: Use A5:SQL Mk-2 (x64)
Tips for a Smooth Installation
Conclusion:
Both methods ultimately utilize the Microsoft Store, ensuring the app's safety and reliability. Whether you prefer browsing within the Store or starting via the website, both approaches lead you to successfully download and install A5:SQL Mk-2 (x64).A5:SQL Mk-2 (x64) FAQs
How to download and Install A5:SQL Mk-2 (x64) on Windows PC via the NWindows Store
How to Search and Download A5:SQL Mk-2 (x64) for PC Windows?