Explore the Knowledge Base
Knowledge Base Articles for DeZign for Databases
Constraints
Data modeling
- About Primary Keys and auto increment columns
- Check constraint benefits
- Primary key data type propagation
- Identifying and non-identifying relationships
- Store images in the database
- Data type for storing rich text format (RTF)
- My database does not support domains. Can I still use them?
- How can I create a VARCHAR(MAX) field?
- MS SQL Server Data Type TEXT or VARCHAR?
Database Objects
- How to implement an auto increment column in MS Access?
- Autoincrement Primary Key for Oracle
- Auto increment Primary Key for InterBase
- Copying entities
- Primary key data type propagation
- Keywords in default values
- Merging projects
- About Min and Max values for Oracle databases
- How do I move an attribute in the list of attributes?
- How can I define the MySQL table type?
- Ordering stored procedures
- Selecting related tables
- My database does not support domains. Can I still use them?
- How can I define my storage parameters?
- What are domains?
Miscellaneous
- Activating the software
- Can I export the model to XML?
- Import an ERwin data model
- Merging projects
- How to compare a data model with a database?
- How many entities can a diagram/project hold?
- About reserved words
- Data type for storing rich text format (RTF)
- Are the projects compatible between the editions?
- Using the BigQuery STRUCT data type
Reusable objects
Database modification
Diagrams
Printing and reporting
Reverse engineering
- How to connect to an Oracle database?
- How to connect to a Snowflake database?
- How to connect to a Google BigQuery database?
- Connecting to a remote MySQL server
- Import an ERwin data model
- How to make a MS SQL Server structure dump?
- How to make a MySQL structure dump?
- How to compare a data model with a database?
- How to make a DB2 structure dump?
Version control
Knowledge Base Articles for Datanamic DataDiff
- Can I still compare the tables when there is no primary key?
- How does Datanamic DataDiff select the comparison key when adding a table to the project, and why it is not specified for some of the tables?
- How to compare tables with different names?
- Table does not exist message when comparing tables.
- It takes a long time to load a Datanamic DataDiff project with only a few tables in it.
- How to speed up the comparison of data?
- How to handle computed fields?
- Where are the log files saved?
- About meta data change control.
Knowledge Base Articles for Datanamic SchemaDiff
Knowledge Base Articles for Datanamic Data Generator
- About meta data change control.
- Can I use random data from external sources?
- The date format wrong when I generate a SQL script with test data. What to do?
- How to specify the number of rows to generate?
- What is a Data Generator project?
- How to exclude columns for data generation?
- Data generation fails when check constraints are violated.
- Can Datanamic Data Generator connect to a database to use it as a source of data?