最新版 DeZign for Databases v14.4 更新於 2024/4/1
DeZign for Databases
是一個直觀的資料庫設計及建模工具,能幫助開發者以及資料庫管理員來建模、創建以及維護資料庫。此軟體使用實體關係圖(ERDs, data models)以圖形方式設計資料庫,並且自動生成最風行的SQL及桌面資料庫。
DeZign for Databases提供了資料庫應用程式開發的可視化建模環境,讓開發過程便得更簡易,此工具減少了故障開發以及提高您的工作效率。你可以進行可視化資料庫結購,來了解你的資料庫,、創建新的資料庫或反向操作現有的資料庫,去修改、分析及優化
新版介紹
Snowflake support
DeZign for Databases has been adapted to enable data modeling for Snowflake databases. Our software connects to your Snowflake databases and reads out the structure of the database. After the connection with the Snowflake database has been set up, the structure of tables, views, primary key constraints, foreign key constraints, sequences, procedures and functions are loaded into DeZign for Databases.
Generate complete new Snowflake databases, generate alter scripts to update your Snowflake database, or connect and update your data model when your Snowflake database has changed outside of DeZign for Databases. As you can read, all existing DeZign for Databases features are supported for Snowflake databases.
系統需求
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:
Snowflake, Oracle, MS SQL Server, MySQL, PostgreSQL, MS Access, InterBase, Firebird, MS Azure, Sybase, dBase, Paradox, Clipper, SQLite, Google BigQuery.
Visual Database Modeling
Diagramming. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases. In your diagram you can visually make a design using entities, relationships, subcategories, group boxes and text blocks. Entity symbols are used to define database table structures, including details about columns (attributes), primary keys, null, unique, foreign keys, domains, check constraints, .... Relationships are drawn between entities and can include a name, abbreviation, description and the cardinalities (zero, one, many, ...). The diagram editor user interface fully supports drag-and-drop of entities, relationships, subcategories, group boxes and text blocks.
Industry standard design notations. You can draw your data model based on modeling notations defined by IDEF1X or Crow's Foot (Information Engineering).
Multiple display modes. The software will display model information at various levels. These display modes can be used at various stages of model development or can be used to convey model information in abstract or in varying depths of detail.
Pan and zoom window. Quickly navigate around large diagrams with the Pan and Zoom window. This window gives you a "birds-eye" view of your diagrams.
ER-Modeling. DeZign for Databases supports the ER-modeling techniques. Some advanced features like N:M-relationships (many-to-many relationships) and sub categories (inheritance) are also supported. "DeZign for Databases" will take care of the translation of the model to the physical database.
Forward and Reverse Engineering
Forward engineering. DeZign for Databases can generate databases directly from your models (ER-diagrams). For SQL databases, the SQL DDL scripts to create your database will be generated. For non SQL databases, the physical database files will be generated directly. You can control what will be generated. Generate individual parts of your model. Generate tables, relations, indexes, domains, sequences, procedures, triggers and views.
Reverse engineering. Derive a graphical model from existing databases, for both relational and big data platforms. You can import an existing database by connecting to the database directly or by importing a SQL DDL script. Your complete database will be imported including tables, sequences, triggers, procedures and views. While importing the database, the software analyzes the database to find relationships not expressly defined in the database.
Database/Model Synchronization
DeZign for Databases offers bi-directional compare and synchronize functionality for all synchronization use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model.
When any change is made to either the model or database, DeZign for Databases provides a comprehensive comparison of all differences. Changes can be moved from model-to-database (generates intelligent modification scripts) or database-to-model. With the comparison options you can control what will be seen as a difference.
Collaborate and Share, Securely
Next to single file projects, DeZign for Databases supports folder-based projects. It then creates a .dezproj file and the folders that keeps the model's objects and diagrams.
The main advantage of folder-based projects is that it's adjusted to store project files in Version Control Systems such as Git: the project data is split over multiple files (one file for each object), and merge conflicts are less likely. You can use Git source control to manage your files and collaborate with others.
Another option is to store your model in a (server-based) repository database. The Datanamic Repository is a central repository database to store your models. With the Datanamic Repository more than one user can work on the same model.
Model Maintenance
Diagram management. DeZign for Databases extends your modeling power with subdiagrams. A project is a set of one or more subdiagrams that contains the specification of an entire model. You can break a large or complex model into smaller, easier to maintain subdiagrams.
Object browser. Rather than presenting a picture of the model in the traditional diagram window manner, the Object Browser provides an organized, ordered view of the model and its contents. You can create, navigate and modify a model in the Object Browser.
Labeling. Organize the objects in your project into meaningful groups with labels. This way you can quickly and easily filter and report on the data that is of most interest to you.
Reporting
DeZign for Databases provides flexible, customizable reporting and printing capabilities.
HTML, MS Word and PDF reports. You can generate HTML, MS Word and PDF formatted reports for easy deployment of design information. Several reports with different levels of detail can be generated. Optionally the diagram(s) can be inserted as a picture.
Export data dictionary to CSV. You can export the database objects in the data dictionary/model to comma-sepated values files (CSV). For each type of object a file will be exported.
Export diagram as image. The diagram itself can be printed or exported as a png, bitmap, jpeg-image, gif-image or windows metafile.
Better Database Designs
Our tool is meant to speed up and simplify the creation of database designs and to minimize human errors. The software helps with creating correct data definition language (DDL) and increases your chances to create a high-performance database. Good designs lessens the maintenance efforts and decreases probability of failures.
Model validation. You can validate a model for errors any time during the design process. During validation, the tool checks to make sure the elements in your data model are correct and complete.
Automatic foreign key migration. DeZign for Databases supports the logical and physical data-level from a single specification achieved by using automatic foreign key migration at design-time.
A modification to a property of a relationship or to a primary key will automatically affect foreign keys.
Domains. Domains are reusable user-defined types or "attribute templates" that promote consistent domain definitions. You construct a domain by specifying a name, datatype, default value and validation rules. Afterwards, you can reuse them in your project by applying them to attributes.
Attribute packages. Attribute packages are pre-defined, reusable sets of attributes that promote consistent attribute definitions. You can share attribute packages between data models/projects.
Name templates. The name templates editor lets you create naming rules for entities, relationships and constraints that can be reused across the model.
Supported Database Platforms
DeZign for Databases supports more than 15 databases including Oracle, Snowflake, MySQL, MS SQL Server, MS Access, DB2, Google BigQuery, Azure SQL and PostgreSQL.
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.