xyz軟體王

xyz資訊工坊

會員登錄
最新消息
您現在的位置:網站首頁 >> 專業軟體光碟 >> Windows 系統應用軟體 >> 商品詳情
您可能感興趣:
dbForge Studio 2019 for MySQL v8.2.23 Enterprise Edition 一個非常好用而又專業的mysql界面工具
dbForge Studio for MySQL是用於MySQL和MariaDB數據庫開發、管理和管理的通用GUI工具。IDE允許您創建和執行查詢、開發和調試存儲例程、自動化數據庫對象管理、通過直觀的界面分析表數據。MySQL客戶機提供數據和模式比較和同步工具、數據庫報告工具、帶有調度的備份選項等等。

此外,dbForge Studio for MySQL是MySQL工作臺的完美替代品。看看我們的工具在MySQL工作臺上的優點吧!

數據庫開發

通過以下功能,構建、編輯和運行查詢以及測量和優化查詢性能變得簡單得多:

數據庫設計

數據庫設計工具允許用戶創建數據庫關系圖、對象、項目,以及在用戶友好的界面中高效地比較和同步數據庫架構。

數據庫管理

使用這些功能,用戶可以管理其帳戶、設置權限、監視打開的會話及其活動,以及執行表維護。此外,還可以在備份文件中備份和還原數據庫。

數據報告和分析

創建數據報表和數據透視表以及數據比較和同步可能需要花費大量時間和精力,而使用以下功能可以提高工作效率

Description:
dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more.

In addition, dbForge Studio for MySQL is a perfect alternative to MySQL Workbench. Check out the pros of our tool over MySQL Workbench!

Database Development
Building, editing, and running queries, as well as measuring and optimizing query performance get much simpler with the following functionality:

Database Design
Database design tools allow users to create a database diagram, objects, projects, as well as to compare and synchronize database schemas efficiently and in a user-friendly interface.

Database Administration
With these features, users can manage their accounts, set up permissions, monitor open sessions and their activity, as well as perform table maintenance. In addition, it is possible to back up and restore databases to/from a backup file.

Data Reports and Analysis
Creation of data reports and pivot tables, as well as data comparison and synchronization may take much time and efforts while your work can be more productive using the following features:

Features

dbForge Studio for MySQL is compatible with:
-All MySQL server versions
-All MariaDB server versions
-Percona PAM Authentication for MySQL
-Sphinx Search Engine

Intelligent SQL Coding
-Intelligent code completion, formatting, MySQL prompt, and code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly.

Database Compare and Sync
-When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:
-Compare and sync data and schemas
-Schedule regular database sync tasks
-Generate comparison report

Data Generator
-Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.

Documenter A tool for generation of MySQL and MariaDB database documentation. Documenter allows you to:
-Retrieve an overview of the database structure
-View inter-object and inter-database dependencies
-Customize documentation with style templates
-Generate documentation files in the HTML, PDF and Markdown formats

Visual Query Builder
-Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.

dbForge Studio for MySQL - Visual Query Builder Database Designer

-Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:
-Viewing foreign key relations
-Displaying DB objects with properties
-Execution of stored routines

dbForge Studio for MySQL - Database Designer Import/Export Data
-Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available.

dbForge Studio for MySQL - Import/Export Data Database Backup
-Dump databases in SQL format and schedule regular MySQL database backups. Use 5 levels of file compression and wide set of options to fine-tune backups. Save your settings and connections as a project for the next time or to use in the command line.

dbForge Studio for MySQL - Database Backup Database Administration

Tools for MySQL database administration and management include means for:
-Managing user privileges
-MySQL service control
-Managing server variables
-Table maintenance
-Managing server sessions

dbForge Studio for MySQL - Database Administration MySQL Debugger
-The first debugger for MySQL that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution.

Table Designer
-Visual designer for modifying or creating table structure, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based on the name you enter.

Database Refactoring
-Improve MySQL database design by applying small changes. When such changes are performed, they are fully transparent and application takes care of all dependencies in the database:
-Renaming database objects with preview
-Refactoring script

Improve multi-second queries using Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:
-Offers visual query profiling
-Compares profiling results

Report and Analysis
-Data reporting is performed using wizard with rich feature set, manually, or via command line. Ready reports can be imported to 9 formats and delivered to their recipients.
-Group and summarize your data in pivot tables to make it easier to read and understand.

Database Projects
-The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.

Copy Database
Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:
-Customize copying settings
-Copy databases together with data
-Drop a database if it already exists on a target server

MySQL and MariaDB Connectivity:
-Support for all MySQL server versions 3.23-8.0
-Support for all MariaDB server versions 5.5-10.4
-Secure connections via SSL/SSH
-HTTP connections via PHP tunnel
-Support for UTF-8 databases
-Work with MySQL embedded server
-Direct access to MySQL server without client libraries
-MySQL pluggable authentication and Windows authentication on connecting to MySQL server (PAM)
-Support for Windows authentication when creating connection to MySQL server
-Working with MySQL on Amazon RDS and on Amazon Aurora
-Percona PAM Authentication for MySQL
-Sphinx Search Engine
-Galera Cluster
-Google Cloud Platform
-Alibaba Cloud
-Azure MySQL

System Requirements:
OS:Microsoft Windows XP,7,8, 8.1,10, Windows Server 2008, 2012
CPU:2 GHz or higher processor
Memory:1024 MB RAM
Space:150 MB of free hard disk space
dbForge Studio 2019 for MySQL v8.2.23 Enterprise Edition
Whats New:
-Problem with connection to Azure Database for MySQL is fixed (T289434).

Homepage
https://www.devart.com/
站內搜尋

商品清單