PostgreSQL Maestro 資料庫開發及管理的首選軟體
PostgreSQL Maestro 是一款功能強大的GUI圖形化介面資料庫開發及管理工具,支持所有最新的PostgreSQL server及7.3版,功能包括表空間、元引用、資料數據的導入/導出、創建、編輯、預覽等,並且可以執行和查詢SQL腳本,管理用戶和特權。
PostgreSQL Maestro is the premier PostgreSQL GUI admin tool for database management, control and development. Key features include:
- Support for all versions of PostgreSQL versions starting from 7.3 including roles, tablespaces, partitions, extensions, and so on;
- User-friendly interface with navigation style, well-described wizard system, quick launch panel for performing the commonest operations;
- Easy PostgreSQL database objects management;
- Visual Database Designer with reverse engineering and a lot of other features;
- PL/pgSQL Debugger to investigate and fix your PL/pgSQL code in the shortest way;
- Comfortable access to the PostgreSQL security features;
- Powerful tools for working with SQL queries including Visual Query Builder;
- Flexible customization of the application.
The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.
特色
Easy database object management
Browse, create, edit, duplicate, rename and drop all schema objects like tables, views, functions or triggers in the simplest way possible.
Database Designer
Simplify your data modeling tasks. Create tables and relations in a few mouse clicks. Print diagrams or export them to a number of graphical file formats.
Data management and analysis tools
Browse, edit, print, sort, group and filter your data using wide spectrum of available tools including master-detail views. Build graphical diagrams and OLAP cubes.
SQL Editor and Visual Query Builder
Enjoy feature-rich SQL Editor with code completion, code folding and SQL formatter or build your queries visually.
Data export and import tools
Export your data to as many as 20 most popular file formats or import data from Excel, CSV, XML and other files.
Security management tools
Make your server safe and secure with powerful tools provided by PostgreSQL Maestro.
Schema refactoring tools
Split denormalized tables, generate DML procedures or updatable views and check nullable columns with a few mouse clicks.
BLOB management tools
View and edit contents of BLOB fields in your database as hexadecimal, text, image, HTML, or PDF. Export/import BLOBs to/from external files.
PL/pgSQL Debugger
Debug your PL/pgSQL functions using traditional debugging features such as setting breakpoints, viewing variable values, and examining the call stack.
新版特色
- This version of the software comes with PostgreSQL 12 compatibility.
- Support for generated columns has been added (PostgreSQL 12). Values of such columns are automatically computed based on a predefined expression. PostgreSQL currently implements only stored generated columns.
- To create a stored generated column, just provide the generation expression in the Formula edit box.In Data Grids and Data Input Forms generated columns are marked by a green calculator.
- Support for planner support functions (PostgreSQL 12) has been added. It is possible to attach a planner support function to a SQL-callable function to improve optimizer support for it.
- In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.
System Requirements
Client environment
· Pentium PC or higher;
· Windows NT4/2000/XP/Vista/Windows 7/Windows 8/Windows 10/Windows 11; · 512 MB RAM (1 GB recommended);
· 25 MB of free hard disk space;
· SVGA-compatible video adapter.
Server environment
· PostgreSQL from 7.3 to 16.
MySQL Tools Family
Proven tools with all the features required to satisfy your MySQL needs.
SQL Maestro for MySQL
A complete and powerful database management and development tool for MySQL and MariaDB.
Data Wizard for MySQL
Powerful data export/import tools for MySQL combined with a flexible task scheduler.
Data Sync for MySQL
Compares MySQL database contents and synchronizes differences.
Database Converter for MySQL
Migrates any database to MySQL in a few mouse clicks.
Code Factory for MySQL
Gives you a powerful set of tools to edit SQL scripts and build SQL statements visually.
Microsoft® SQL Server™ Tools Family
Powerful applications to manage any SQL Server from 7.0 to 2022, Azure SQL Database, and SQL Server Compact Edition.
MS SQL Maestro
A comprehensive IDE for all DBAs and developers. Use it to manage any SQL Server from 7.0 to 2022 and Azure SQL Database!
MS Compact Maestro
An easy to use database management tool for SQL Server Compact Edition
MS SQL Data Wizard
A number of data management tools for Microsoft SQL server.
MS SQL Data Sync
Compares SQL Server database contents and synchronizes differences.
MS SQL Database Converter
Migrates any database to SQL Server quickly and easily.
MS SQL Code Factory
Handy application to manage SQL queries and scripts.
PostgreSQL Tools Family
The essential package of tools for PostgreSQL admins and developers.
PostgreSQL Maestro
A state-of-the-art database management and development tool for all the PostgreSQL users.
PostgreSQL Data Wizard
Various PostgreSQL data management tools with a flexible task scheduler.
PostgreSQL Data Sync
Compares PostgreSQL database contents and synchronizes differences.
PostgreSQL Database Converter
Migrates any database to PostgreSQL in just five simple steps.
PostgreSQL Code Factory
Equips developers and DBAs with the productivity tools to improve SQL code quality and accuracy.
SQLite Tools Family
The set of premier GUI tools designed to meet the requirements of all the SQLite users.
SQLite Maestro
Makes SQLite database management even more easier than one can imagine.
SQLite Data Wizard
A complete set of SQLite data management tools.
SQLite Data Sync
Compares SQLite database contents and synchronizes differences.
SQLite Database Converter
Converts any database to the SQLite format.
SQLite Code Factory
An easy-to-use tool aimed at the SQL queries and scripts development.
Firebird Tools Family
The complete toolkit of Firebird database management solutions.
Firebird Maestro
Complete Firebird management IDE combining user-friendly interface with the latest Firebird 2.1, 2.5, 3.0 and 4.0 features support.
Firebird Data Wizard
Powerful Firebird data conversion tools united in a single shell.
Firebird Data Sync
Compares Firebird database contents and synchronizes differences.
Firebird Database Converter
Migrates any database to Firebird.
Firebird Code Factory
An optimum solution for SQL queries and scripts management.
Oracle Tools Family
Premier Windows GUI frontends for Oracle management, control and development.
Oracle Maestro
Your best guide in the world of Oracle.
Oracle Data Wizard
Data Export/Import and SQL Dumping tools for Oracle.
Oracle Data Sync
Compares Oracle database contents and synchronizes differences.
Oracle Database Converter
Transfers any database to Oracle.
Oracle Code Factory
A light-weight tool to edit SQL scripts and build SQL statements visually.
SQL Anywhere Tools Family
State-of-the-art database tools for SAP SQL Anywhere.
ASA Maestro
A comprehensive database management tool for SAP SQL Anywhere.
ASA Data Wizard
A complete set of SQL Anywhere data management tools.
ASA Data Sync
Compares SQL Anywhere database contents and synchronizes differences.
ASA Database Converter
Transfers any database schema and data to SQL Anywhere.
ASA Code Factory
Helps you to create SQL queries and scripts.
DB2 Tools Family
High-quality DB2 tools which are as easy in use as Windows explorer.
DB2 Maestro
DB2 database management has never been easier.
DB2 Data Wizard
A full set of data management tools for DB2.
DB2 Data Sync
Powerful, fast and easy to use DB2 comparison tool.
DB2 Database Converter
Migrates any source database to the DB2 database server.
DB2 Code Factory
Equips users with a toolkit to build and execute compound SQL statements.
MaxDB Tools Family
Full stack of powerful MaxDB management tools.
MaxDB Maestro
A feature-rich GUI tool for MaxDB administration and database development.
MaxDB Data Wizard
Data Export, Data Import, and BLOB loading tools for MaxDB.
MaxDB Data Sync
Compares MaxDB database contents and synchronizes differences.
MaxDB Database Converter
Migrates any database to MaxDB.
MaxDB Code Factory
All you need to work with SQL queries and scripts.