最新版 DeZign for Databases v14.1 更新於 2024/1/1
DeZign for Databases
是一個直觀的資料庫設計及建模工具,能幫助開發者以及資料庫管理員來建模、創建以及維護資料庫。此軟體使用實體關係圖(ERDs, data models)以圖形方式設計資料庫,並且自動生成最風行的SQL及桌面資料庫。
DeZign for Databases提供了資料庫應用程式開發的可視化建模環境,讓開發過程便得更簡易,此工具減少了故障開發以及提高您的工作效率。你可以進行可視化資料庫結購,來了解你的資料庫,、創建新的資料庫或反向操作現有的資料庫,去修改、分析及優化
新版介紹
Parallel modeling with folder-based projects
In previous versions, the project data was always stored in a single XML file, which is not well suited for version control integrations. In version 14 we introduce folder-based projects. The project data is split over multiple files (one for each object). Its main advantage is that it's adjusted to store project files in Version Control Systems such as Git: the project data is split over multiple files, and merge conflicts are less likely.
When you open a folder-based project, DeZign for Databases will automatically check the files for merge conflicts.
Available in the Professional and Expert edition
Stay organized with the Labeled objects panel
In DeZign for Databases, you can use labels to categorize your database objects such as entities, views, attributes, etc. Labels are like folders, but with a twist—you can apply several labels to an object, then later find the object by clicking any of its labels from the new Labeled objects browser in the left panel.
It is also possible to create sublabels (nested labels). Sublabels or nested labels, allow you to create a sophisticated organizational structure in the vast swamp of objects and diagrams in your project.
Available in all editions
On-diagram editing
As you design a model, the names of entities and attributes may change. In version 14 you can edit objects directly in the diagram window (Instead of opening the Entity dialog each time you want to change a name).
To invoke the inplace on-diagram editor, simply click on the item you want to edit and hold down the left mousebutton for one second. You can also hold down the Alt-key and click on the item you want to edit.
Available in all editions
Easily switch to another project format
Version 14 supports two types of project formats: folder-based project and a single file project. Single file based projects (.dez files) are best suited to single user development with the project file placed on the developers local drive.
Many projects will start out as single user project and later be migrated into a folder-based project for larger team access (with Git).
You can easily switch from one format to another in the Save as dialog.
Available in the Professional and Expert edition
Label objects in the Object browser
You can now label objects via the object's context menu in the Object browser. You can also drag objects from the Object browser to the and drop the object on the label in the Labeled objects browser to label an object.
Available in all editions
Merge conflict detection
Merge conflicts are almost unavoidable when there are multiple people involved in the DevOps process. These can arise when two users are making changes to the same object. DeZign for Databases V14 will detect merge conflicts that need to be resolved when opening your project.
Available in the Professional and Expert edition
PostgreSQL 15 support
The list of supported databases keeps growing. We added support for PostgreSQL 15. DeZign for Databases has been enhanced for new features introduced in PostgreSQL 15.
Forward engineering is available in all editions. Reverse engineering is available in the Professional en Expert edition.
系統需求
Operating System: Windows 11/10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Internationalization:
Our products are compatible with data stored in any language. The interface and documentation are in English.
Databases:
Oracle, MS SQL Server, MySQL, PostgreSQL, MS Access, InterBase, Firebird, MS Azure, Sybase, dBase, Paradox, Clipper, SQLite.
Model-Driven Collaboration
If you need to develop large models with many modelers, you might prefer to store your model in a (server-based) repository database. The Datanamic Repository is a central repository database to store your data models. With the Datanamic Repository more than one user can work on the same data model. You can connect to the Datanamic Repository with the Teamwork Edition of DeZign for Databases.
Database Specific Models or Database-Independent Models
資料庫特定模型或獨立於資料庫的模型
DeZign for Databases supports modeling for a specific target DBMS (physical) and it supports database-independent modeling with portable data types (logical).
Customizable Model Reports 可自訂的模型報告
Customizable data model reports with different levels of detail can be generated. Descriptions and other relevant information will be exported to HTML, MS Word or PDF.
Intuitive Modeling Environment 直觀的建模環境
The industry standard modeling processes are followed and the tool has a well-designed user interface which decreases the user's learning curve.
Better Database Designs 更好的資料庫設計
You can validate a model for errors any time during the design process. During validation, DeZign for Databases checks to make sure the elements in your model are correct and complete. Reusable objects (domains and attribute packages) and name templates promote consistent database object definitions.
Supported Databases 支持的數據庫
DeZign for Databases支持超過15個數據庫,包括Oracle,MySQL,MS SQL Server,MS Access,DB2,Azure SQL和PostgreSQL。
Below the list of supported databases. Please note that reverse engineering existing databases is only available in the Professional and the Expert edition. Alter/update database functionality is only available in the Expert edition
Database | Diagramming | Forward engineering | Reverse engineering |
Compare database to model and update model | Compare database to model and update/alter database |
dBase (1) | X | X | Native connection | X | - |
DBISAM 4 (1) | X | X | Native connection | X | - |
Firebird 1.5, 2, 3 | X | X | Native connection and SQL file import | X | X |
FoxPro (1) | X | X | Native connection | X | - |
IBM DB2 Univ. DB 7, 8, 9 | X | X | OLEDB connection and SQL file import | X | - |
InterBase 6, 7, 2009, XE | X | X | Native connection and SQL file import | X | X |
Informix 9 | X | X | SQL file import | X | - |
MS Access 2000, 2003, 2007, 2010 and 2013 (2) | X | X | ADO/ODBC/Native connection | X | X |
Azure SQL | X | X | Native connection and SQL file import | X | X |
MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017 and 2019 | X | X | Native connection and SQL file import | X | X |
MySQL 4, 5, 6 and 8 | X | X | Native connection (with support for SSL) and SQL file import | X | X |
Oracle 8, 9, 10, 11, 12, 18, 19 and 21c | X | X | Native connection and SQL file import | X | X |
Paradox (1) | X | X | Native connection | X | - |
Pervasive v8, PSQL v9 | X | X | SQL file import | X | - |
PostgreSQL 7, 8, 9, 10, 11, 12, 13, 14 and 15 | X | X | Native connection (with support for SSL) and SQL file import | X | X |
SQLite 3 (2) | X | X | Native connection and SQL file import | X | X |
Sybase ASE 11, 12 | X | X | SQL file import | X | - |
(1) For dBase, DBISAM, FoxPro and Paradox, table files are generated directly.
(2) For MS Access and SQLite, the database files are generated directly.
Standard
» ER Diagramming
» Generate databases
» Generate documentation
Professional
» ER Diagramming
» Generate databases
» Generate documentation
» Folder-based projects (for Git)
» Reverse-engineer existing databases
» Update model from database
Expert
» ER Diagramming
» Generate databases
» Generate documentation
» Folder-based projects (for Git)
» Reverse-engineer existing databases
» Update model from database
» Update database from model
» Access to Datanamic Repository
Feature | Standard | Professional | Expert |
General | |||
Copy and paste and drag and drop within or between models. | X | X | X |
Undo-support. | X | X | X |
Find objects by name or other object properties. | X | X | X |
Open file format (XML). | X | X | X |
Editor with syntax highlighting. | X | X | X |
Grid based editing in list of attributes, indexes, triggers etc. | X | X | X |
Labeling objects to organize your data model. | X | X | X |
To-do list. | X | X | X |
Global search and replace (with regular expressions). | X | X | X |
Visual Data Modeling | |||
ER diagramming with support for Crow's Feet and IDEF1X notation. | X | X | X |
DBMS-specific data models. | X | X | X |
Database-independent data models. Forward engineer one model to multiple databases. | X | X | X |
Define entities, attributes, domains, views, indexes, procedures, sequences, triggers, relationships. | X | X | X |
Identifying and non-identifying relationships. | X | X | X |
Auto layout of objects in diagram. | X | X | X |
Dynamic highlighting of related objects. | X | X | X |
Drag and drop database objects. | X | X | X |
Model validation. | X | X | X |
Attribute color coding. | X | X | X |
Automatic propagation of foreign keys (optional). | X | X | X |
Attribute packages (reusable sets of attributes for consistent attribute definitions) | X | X | X |
Multiple display modes (entities, all attributes, key attributes etc). | X | X | X |
Pan and zoom window ("birds-eye" view of diagrams). | X | X | X |
Name templates for database objects like constraints, foreign key columns, indexes etc. | X | X | X |
Naming tool for batch renaming of objects. | X | X | X |
Manage indexes on keys. | X | X | X |
Subdiagrams Management | |||
Subdiagrams can be created to represent objects related to given subject area. | X | X | X |
Create subdiagrams for selected objects. | X | X | X |
Automatically create a subdiagram for each schema. | - | X | X |
Version Management | |||
Automatically archive a version of the model when you forward or reverse engineer. | X | X | X |
Compare model versions. | X | X | X |
Manually archive current model. | X | X | X |
Switch between archived model versions. | X | X | X |
Reporting | |||
Print diagram (scalable). | X | X | X |
Export diagram as image (JPG, GIF, BMP, WMF). | X | X | X |
Export data dictionary to CSV files. | X | X | X |
Generate configurable HTML (navigable), PDF, MS Word database/model documentation. | X | X | X |
Load and save report templates. | X | X | X |
Databases | |||
Support for more than 15 databases (See list of supported databases). | X | X | X |
Editor for data type conversion rules. | X | X | X |
Switch to another target database. | X | X | X |
Generate database from data model. | X | X | X |
Generate DDL from data model. | X | X | X |
Generate drop script. | X | X | X |
Import databases through native database connections. | - | X | X |
Import SQL scripts (DDL). | - | X | X |
Creates a model upon completing a reverse engineering of a database or script file. | - | X | X |
Smart Relationship Finder to infer non declared relationships. | - | X | X |
Compare model to database and update model. | - | X | X |
Compare model to SQL script and update model. | - | X | X |
Define custom comparison rules. | - | X | X |
Compare model to database and update database (generate intelligent alteration code). | - | - | X |
Compare model to SQL scripts and update database. | - | - | X |
Compare model versions and generate intelligent alteration code. | - | - | X |
Conditional generation. A conditional generation directive causes the schema generator to conditionally suppress the generation of portions of the model. | - | - | X |
Collaboration | |||
Folder-based projects (for storage in Version Control Systems such as Git) | - | X | X |
Access to the Datanamic Repository. | - | - | X |
Commit changes to the repository. | - | - | X |
Get latest version of your model from the repository. | - | - | X |
Conflict resolution when committing changes to the repistory. | - | - | X |
Datanamic DataDiff
Datanamic DataDiff for Oracle is a powerful and easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization.
Datanamic DataDiff for MS SQL is a professional grade, easy-to-use MS SQL Server tool that compares and synchronizes data of two MS SQL Server databases. The tool enables users to synchronize the data in complete databases or selected tables with just a few mouse clicks. Set up your comparison plan with flexible comparison options, compare the databases, navigate through the differences in an intuitive differences grid, and safely synchronize all or only a selection of records. A command line utility is available to automate your data compare and synchronize process.
Datanamic DataDiff for MySQL automates and simplifies the migration of MySQL data changes from one database to another database (for example from development servers to production servers). With its intuitive user interface, the tool gives you the full picture of all data differences in just a few seconds.
Datanamic DataDiff for PostgreSQL is a powerful and easy-to-use PostgreSQL tool for data comparison and synchronization. Compare data for selected tables in two databases, view data differences and publish changes quickly and safely. Flexible comparison and synchronization options allow you to set up a customized comparison key and to select tables and fields for comparison and for synchronization. You can synchronize directly on the PostgreSQL database or generate a synchronization SQL script.
Datanamic DataDiff for MS Access is an easy-to-use tool for comparing and synchronizing data in two MS Access databases. It helps you keeping your databases synchronized. You connect to the MS Access databases, select the tables you want to compare, you compare, review the differences, and finally, click "synchronize" to update the data the selected destination database.You can save your comparison plan to a project file so that you can use the same settings again later.
Datanamic DataDiff MultiDB is a powerful and easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization.
Datanamic DataDiff for SQLite
SQLite 3.x.
Datanamic SchemaDiff
Datanamic SchemaDiff for Oracle/MS SQL enables you to compare and synchronize two database schemas. The tool will give you the full picture of all schema differences. Once your database schemas are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to the source database.
Datanamic SchemaDiff for MySQL is an easy-to-use database schema comparison and synchronization tool. The tool will give you the full picture of all database schema differences. Once your database schemas are compared, you can view the object differences and generate the necessary synchronization script to update the destination database.
Datanamic SchemaDiff for PostgreSQL allows you to compare the structure of two PostgreSQL database, view the schema differences, and automatically generate Data Definition Language (DDL) scripts (synchronization scripts) that you can use to update the schema of the destination database to match the schema of the source.
Datanamic SchemaDiff for MS Access enables you to compare and synchronize MS Access database structures. The tool will give you the full picture of all structure differences. Once your database schemas are compared, you can view the differences and let the application update the destination database and make it identical to the source database. A wide array of comparison options let you control how the comparison is done. A command line utility is included. With this command line utility you can further automate your database synchronization process.
Datanamic SchemaDiff MultiDB is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases. Multiple databases are supported. You can compare and synchronize Oracle, MySQL, MS Access, MS SQL Server and PostgreSQL database schemas.
Datanamic Data Generator
Datanamic Data Generator for Oracle is a powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes. The tool reads your Oracle database and displays tables and columns with their automatically assigned data generation settings. You can customize these data generators if desired. The tool can be used to generate test data from scratch or from existing data. A large collection of predefined data generators based on lists (such as cities, currencies, names, addresses, and much more) or expressions (such as postal codes for example) is included. You can create your own named generators which you can use in other test data generation projects also.
Datanamic Data Generator for MS SQL can be used to create realistic test data that you need to verify the behaviour of your database applications. The tool generates data that is appropriate for the database schema (with referential integrity support). The data can be inserted in the database directly or you can generate a SQL script with insert statements.
Datanamic Data Generator for MySQL is an easy-to-use test data generator that generates realistic data for database testing purposes.
Datanamic Data Generator for PostgreSQL Whether you are developing a new PostgreSQL database application from the ground up or prototyping to prove a concept, you need test data to run your application against. To test an applications performance effectively, you should have enough test data to expose potential database performance problems. Datanamic Data Generator for PostgreSQL comes with features that will help you generating meaningful test data for your PostgreSQL database quickly.
To be able to test a database application which works with MS Access, you need test data. If possible, realistic data. You can make this test data manually. That is quite error prone and very time consuming. The solution is Datanamic Data Generator for MS Access. This is a tool that generates realistic test data automatically.
Datanamic Data Generator MultiDB is a powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes.
Datanamic Data Generator for Azure MS Azure (all versions).
Datanamic Data Generator for MS Access MS Access 2000, 2003, 2007, 2010 and 2013.
Datanamic Data Generator for SQLite SQLite 3.x.
Datanamic MultiRun
Datanamic MultiRun for Oracle is a simple tool to quickly execute multiple SQL scripts against multiple Oracle databases.
Datanamic MultiRun for MS SQL is a simple tool to quickly execute multiple SQL scripts against multiple MS SQL databases.
Datanamic MultiRun for MySQL is a simple tool to quickly execute multiple SQL scripts against multiple MySQL databases.
Datanamic MultiRun for PostgreSQL is a simple tool to quickly execute multiple SQL scripts against multiple PostgreSQL databases.
Datanamic MultiRun MultiDB is a simple tool to quickly execute multiple SQL scripts against multiple databases. The tool supports multiple database platforms. MySQL, Oracle, PostgreSQL and MS SQL are supported.