商品明細

DbVisualizer 資料庫開發

商品簡述
DbVisualizer是一款萬用的資料庫工具適用於開發人員、資料庫管理員(DBA)和分析人員,可以在各類型資料庫的操作系統上使用,支援Windows,Linux和macOS

商品介紹

本產品出貨為最新版本。
如需購買或了解內容請來電(2749-1909)或來信(sales@ahasoft.com.tw)業務部
___________________________________________________________________


支援多種資料庫

DbVisualizer通過了主要資料庫和JDBC驅動程式的測試,對於產業中更常用的資料庫也增加特定功能的支援,其中一些功能如下:

  • 資料庫特定物件的管理
  • CREATE、ALTER、DROP、RENAME等的可視化動作
  • 建立、編輯及彙編過程、函數和觸發器
  • 說明計畫支援
  • 架構導出
  • 比較編輯器及結果


支援多平台
DbVisualizer無縫整合Windows、macOS、Linux/UNIX等支援的作業系統可設定按鍵綁定以及自定義應用程式的外觀。

使用者介面

DbVisualizer有一個選項基礎的使用者介面,提供對版面、資料庫物件、編輯器等很多的控制,還有一些選項可以隱藏使用者介面的某些區域,以更好地符合個人喜好和螢幕實際使用情況。

連線管理

DbVisualizer是JDBC基礎工具包,市場上幾乎所有的資料庫都有JDBC驅動程式,支援連線到本地、SSH遠端、嵌入式資料庫等,連線管理是彈性的,可以透過逐步指導設定連線或自定義連線資訊。

資料庫物件管理

1 資料庫瀏覽器

2 表格

3 過程、函數、包裹及觸發器

4 匯出架構/資料庫5 參考圖表

資料庫伺服器管理

資料庫排程、事件、工作

表格資料管理
1 表格資料瀏覽器/編輯器
2 表格輸出
3 表格資料輸入
4 資料導覽器

Key features

Connect to all major databases with a smart and powerful database tool built for efficiency. Improve your productivity and decrease time to learn by using one single tool for all your databases and OSes.

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 multiple 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
  • A dark theme (Darcula)
 

Supported databases

These are the databases tested with DbVisualizer. Use the links to show JDBC driver information, database specific support and specific DbVisualizer features supported for each of the databases.
 

supported database icon
Amazon Redshift
supported database icon
Azure SQL Database
supported database icon
Db2
supported database icon
Derby
supported database icon
Greenplum
supported database icon
Exasol
supported database icon
H2
supported database icon
IBM Db2 on Cloud
supported database icon
Informix
supported database icon
Microsoft SQL Server
supported database icon
MariaDB
supported database icon
Mimer SQL
supported database icon
MySQL
supported database icon
MySQL Cloud
supported database icon
Netezza
supported database icon
NuoDB
supported database icon
Oracle
supported database icon
Oracle Cloud
supported database icon
PostgreSQL
supported database icon
SAP ASE
supported database icon
Snowflake
supported database icon
SQLite
supported database icon
Vertica
supported database icon
Yellowbrick

Supported OSes

  • Windows
  • macOS
  • Linux
  • UNIX

Requirements

  • Java 8
  • 512MB RAM for Java
  • 80MB disk space
  • JDBC driver (some are delivered with DbVisualizer)