DbVisualizer 是專為開發人員和資料庫管理員開發的一個資料庫工具,有幫於開發和維護資料庫。DbVisualizer是一個完美的解決方案,她是跨平臺的資料庫工具,支援各種關係資料庫。
資料庫瀏覽器
通過所有資料庫對象的譜系導航。瀏覽對象的詳細信息和管理功能。
資料庫管理對象
可視化支援創建、改變和修改資料庫物件的圖表。支援編輯以及編譯程式的程序、功能、套件以及觸發器。廣泛的資料庫的具體支援
表格數據管理
支援編譯表格的數據,像二元制/ BLOB 以及CLOB數據類型。並且可以從檔案中導入。
SQL工具
SQL編輯器,可同時支援自動完成,參數化的SQL, SQL格式化,可視化查詢產生器,解釋計劃,導出結果設定。
資料庫伺服器管理
資料庫管理員的功能,例如資料庫伺服器的資料庫管理,存儲和安全參數。
Table Data Management
類似電子表格的表數據編輯器,包括二進制/ BLOB和CLOB數據類型,從CSV和Excel文件導入。
出口
將數據庫對象和表數據導出為CREATE / INSERT語句,CSV,XML等。支持導出大量的成果。
更新介紹
SQL Editor rebuilt from the ground up
We've completely overhauled the SQL editor in our latest update to be more user-friendly and efficient. This new version includes many improvements, both big and small, all aimed at giving you a great environment to work in.
Find and Replace
We've redesigned the Find and Replace functions for efficiency and ease of use. Now, you can seamlessly switch between searching and replacing text, choose to match by case or whole words, utilize regular expressions for complex searches, and easily navigate between matches. All of this is accessible through a straightforward, inline panel.
Auto-complete
The new SQL editor features a newly developed auto-completion engine designed to be smarter and more accurate than before. Among other things, it handles complex queries better and understands the difference in context between the inner and the outer parts of the query.
Switch between multiple contexts using workspaces
The new release includes support for workspaces, a feature that allows you to switch effortlessly between different work contexts. Each workspace operates independently, complete with its own connections, drivers, scripts, and settings. This functionality makes it easy to manage distinct environments, projects, or client engagements. You have the flexibility to tailor each workspace to suit your specific requirements.
Workspaces can be created and opened through the File -> Workspaces menu.
Create a connection from a database URL
We've introduced an additional method to create database connections, to simplify the setup process. Now, you can begin by entering your database URL, and DbVisualizer will automatically choose the matching drivers for you.
Streamlined handling of the master password
If security is a priority for you, you're likely already familiar with our master password feature. In this new release, we've refined the master password experience to make it more intuitive and less obtrusive. This enhancement allows you to maintain robust security without compromising on ease of use.
Performance and stability fixes
Improved database read performance
We've reduced the need for roundtrips and are handling paging in a smarter way for BigQuery, SingleStore, Vertica, and Oracle databases. This results in better response times and less load on the database.
Additional syntaxes for multi-row inserts
We’ve added support for additional syntaxes for multi-row inserts that can be generated when exporting table data. Using multi-row inserts is essential to the performance when importing large data sets. This release extends the support for the default SQL-92 syntax to also include syntaxes specific to Oracle and Cassandra, as well as the generic union-based syntax.
Smarter memory management
Memory used by scripts and result sets is released faster, making DbVisualizer more efficient when processing large result sets and working with complex scripts.
Improved database support
Oracle
The Grant Privilege action has been added for materialized views, functions, and procedures in Oracle databases. With this addition, you can give privileges to database users to perform operations on the corresponding database object. To give privileges to several objects at once, select them in the database objects tree first.
Microsoft SQL Server
In the new release, default constraints are displayed alongside primary key, foreign key, unique and check constraints in the database objects tree for SQL Server. This allows for a more comprehensive view and easier navigation of the database schema.
SingleStore
Now, DbVisualizer includes the capability to display the DDL for pipelines in SingleStore. This allows users to view the underlying SQL statements that define the structure and configuration of pipelines in their database.
Vertica
Support for procedures in Vertica has been improved. Now it is possible to create stored procedures as well as external procedures in the GUI, and more information about existing procedures is shown both in the Procedures view and in the database objects tree.
Additional improvements across the board
Navigation in the row form editor
We've added navigation buttons to the row form editor in DbVisualizer. This update makes it easier to move between rows within a full result set, while staying within the familiar interface of the row form editor. This enhancement streamlines the process of reviewing and editing data, providing a more seamless and efficient user experience.
Adjust window sizes to the selected application font
As you adjust the font size within the application, the windows will automatically resize to match, ensuring a consistent and optimal viewing experience. This feature not only improves readability but also provides a more comfortable and adaptable user interface, catering to various screen sizes and user preferences.
Security updates
We keep strengthening our security infrastructure by upgrading to the latest version of the Java platform and updating third-party dependencies. This approach to maintaining up-to-date software components is a key part of our commitment to providing a secure environment for our users. DbVisualizer now comes bundled with Java 17.0.9.
Key Features
Multi-database and cross-platform Database Management Tool
- Work with multiple database brands and perform many development and administration tasks from a single tool
- Easily explore your databases
- Automatic graphs of primary/foreign-key constraints
Visually create and manage the database
- Construct and manage database objects with ease
- Multiple object action executions
- Create, Compile and Run functions and procedures
- Object scripting
- Visually compare table and result set data
- Powerful data editing
Write and execute SQL scripts
- SQL IDE with syntax highlighting
- Auto completion
- Parameterized SQL execution
- Chart any result set in nice diagrams
- Tune your queries with integrated explain plans
- Query builder using drag and drop, no manual SQL required
- Visually compare SQL scripts
Data and database transfer
- Export table data in CSV, SQL, HTML, XML,Excel, JSON, Text
- Export all objects in the database including table data or all objects for a specific type
- Import table data from CSV files into existing table or create table from import data
General productivity
- Tasks are executed in background allowing for parallel operations
- Auto save of the workspace
- Resume where you left off with editors preserved between sessions
- Flexible workspace based on a tabbed interface supporting customized layout that is saved between sessions
- Tag DB objects and SQL script files as favorites for instant loads
Supported Databases
|
|
|
Extended support
Oracle
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i - 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MySQL
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
PostgreSQL
PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
Version 8+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Microsoft SQL Server
Microsoft SQL Server is a industry standard relational database management system (RDBMS) used in a wide variety of BI and analytics applications.
Version 2000+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
ClickHouse
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.
Extended support: DbVisualizer supports database-specific object types, functions and features.
SQLite
SQLite implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Version 3.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MongoDB
MongoDB is a cross-platform document-oriented and NoSQL database.
Version 5.0 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Cassandra
Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability.
Version 4.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Google BigQuery
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Oracle Cloud
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i - 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Azure SQL Database
Azure SQL Database is a SQL Server database engine, based on the latest stable Enterprise Edition of SQL Server and fully managed by Azure.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Db2
Db2, or Database 2, is a set of relational database products built and offered by IBM to store, analyze and retrieve data with maximum performance.
Version 8.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Derby
Apache Derby is a rdbms developed by the Apache Software Foundation focusing on easy installation and usage with a minimal disk-space footprint.
Version 10.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Elasticsearch
Elasticsearch is the world’s leading free and open search and analytics solution with an emphasis on speed and scalability.
Version 7.15+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Exasol
Exasol is a high-performance, in-memory, MPP database specifically designed for analytics of large data sets in real time.
Version 6.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Greenplum
Greenplum Database (GPDB) is an advanced, fully featured, open source data warehouse, based on PostgreSQL.
Version 6.13.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
H2
H2 is a open source rdbms that can be embedded in Java applications or run in client-server mode.
Version 1.3 - 1.4, 2.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
IBM Db2 on Cloud
IBM Db2 on Cloud is a fully managed SQL cloud database with point-in-time recovery and high-availability disaster recovery (HADR).
Extended support: DbVisualizer supports database-specific object types, functions and features.
Informix
IBM Informix is an embeddable, high-performance database for integrating SQL, NoSQL, JSON, time-series and spatial data that's designed for analytics int the cloud.
Version 9+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MariaDB
MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL.
Version 10.4+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Mimer SQL
Mimer SQL is a high performance database engine, targeted at mission-critical client/server environments while offering scaleable performance on multiple plattforms.
Version 9.1 - 11 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MySQL Cloud
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Netezza
IBM Netezza is a powerful and highly parallelized Data Warehousing system that is simple to administer and to maintain.
Version 7.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
NuoDB
NuoDB is an SQL-oriented transactional database management system (DBMS) designed for distributed deployment in the cloud.
Version 2.0.4 - 4.3 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Presto
Presto is a distributed query engine for big data using the SQL query language.
Version 0.270+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Redshift
Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.
Version 1.0.7804+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
SAP ASE
SAP ASE is a relational model database server developed by Sybase Corporation.
Version 12.5+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Snowflake
The Snowflake Cloud Data Platform includes a pure cloud, SQL data warehouse.
Version 3.56+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Trino
Trino is an ANSI SQL compliant query engine, that works with a wide variety of BI tools.
Version 360+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Vertica
Vertica is a columnar data storage platform designed to handle large volumes of data, which enables very fast query performance in traditionally intensive scenarios.
Version 6.1.3+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Yellowbrick
Yellowbrick Data Warehouse is an advanced, massively parallel processing (MPP) SQL database designed for batch, real-time, ad hoc, and mixed workloads.
Version 4.1+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
SingleStore
SingleStore (formerly MemSQL) is a cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support.
Version 7.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Basic support
Hive
Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Solr
Solr is a fast, open source enterprise search platform built on Apache Lucene™
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Salesforce.com
The Salesforce Database is powered by Oracle. There are a number of languages that are used for the Salesforce Database including SQL.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Firebird
Firebird is an open-source SQL relational database management system that runs on Linux, Microsoft Windows, macOS and several Unix platforms.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Teradata
Teradata is a Relational Database Management System (RDBMS) suitable for large data warehousing applications.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
CrateDB
CrateDB is a open-source distributed SQL database management system that integrates a fully searchable document-oriented data store.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
HSQLDB
HSQLDB (HyperSQL DataBase) is a SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database.
Version 1.7+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
InterSystems IRIS
Iris is an object-oriented database management system being developed at Hewlett-Packard Laboratories.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
MaxDB
MaxDB is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Actian X (Ingres)
Actian X is a combination of Ingres transactional and Vector analytic databases, integration and a monitoring tool.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
CData Software JDBC Drivers
Easy-to-use JDBC Drivers with powerful Enterprise-level features. Connect JDBC with Salesforce, NetSuite, SharePoint, Secure File Transfer, and more.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
DataDirect's Autonomous REST Connector
Progress DataDirect Autonomous REST Connector is an intelligent, customizable data connectivity solution enabling build and deploy of data connectors without coding.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
FrontBase
FrontBase is a relational database management system written in ANSI C to be scalable and fast.
Version 4+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
HPE NonStop SQL
NonStop SQL is a relational database management system designed for fault tolerance and scalability, offered by HP.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM Db2 iSeries
IBM Db2 is a family of data management products, including the Db2 relational database.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM Db2 z/OS
IBM Db2 for z/OS is a relational database management system that runs on the mainframe.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM IMS
IBM IMS is a hierarchical database management software system for online transaction processing (OLTP) and online batch processing.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
JDBC Drivers for CSV, XML, dBase, MS Access
JDBC driver from Sesame Software for connecting to CSV, XML, dBase and MS Access.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Pervasive
Pervasive PSQL is a relational database developed by Pervasive Software mostly used as embedded database.
Version 9+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Progress
Progress OpenEdge RDBMS supports modern, mission-critical, business applications developed using the OpenEdge application development platform.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
SAP IQ (Sybase IQ)
SAP IQ is a column-based, petabyte scale, relational database software system used for BI, data warehousing, and data marts. Replaced by Yellowbrick.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
SAP SQL Anywhere (Sybase SQL Anywhere)
SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.
Version 11+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
/* SYSTEM REQUIREMENTS */
OS Support:
Windows 64-bit 11/10/8/7
Windows ARM64 11
Linux
macOS 10.11+
Windows: Java 17 is required
macOS: Java 17 is required
Linux: Java 17 is required