Draft:DeZign for Databases

{{AFC submission|d|npov|u=RvDijk123|ns=118|decliner=Caleb Stanford|declinets=20250310073222|ts=20250304144947}}

{{AFC comment|1=The article has several quality issues. Almost all the sentences in the article are not cited. Text includes acronyms which are not explained for a general audience (like DBA and DDL) and has no wikilinked words, possibly copied from somewhere else. Organization into "Features" and "History" reads like a software description and changelog. "Platforms" is uncited. "Support" is uncited and is not clear. Caleb Stanford (talk) 07:32, 10 March 2025 (UTC)}}

----

{{Short description|About a data modeling tool called DeZign for Databases}}

{{Infobox software

| name = DeZign for Databases

| logo =

| caption =

| author = Datanamic

| latest release version = 14.6.2{{cite web |url=https://www.datanamic.com/dezign/versionhistory.html |title=DeZign for Databases version history |publisher=Datanamic |date=January 16, 2025 |accessdate=2025-01-16}}

| latest release date = {{Start date and age|2025|01|16}}

| latest preview version =

| latest preview date =

| status =

| operating system = Windows

| platform =

| language =

| genre = Database design, Database modeling, development

| license = proprietary

| website = {{URL|www.datanamic.com/dezign/}}

}}

DeZign for Databases is a visual database design and modeling tool{{Cite book|url=https://books.google.com/books?id=9x2LawVL_UsC|title=Database Modeling and Design: Logical Design|last1=Teorey|first1=Toby J.|last2=Lightstone|first2=Sam S.|last3=Nadeau|first3=Tom|last4=Jagadish|first4=H. V.|date=Feb 10, 2011|publisher=Elsevier|isbn=9780123820211|pages=234|language=en}} for developers and DBA's. The software uses entity relationship diagrams to graphically design databases and automatically generates the most popular SQL and desktop databases. It is used to construct physical data models, compare and synchronize models with databases, generate DDL scripts and reverse and forward engineer databases.

Features

ER diagramming with support for Crow's Feet and IDEF1X notation
Data model validation
Forward- and reverse- engineering for multiple database platforms such as Snowflake Inc., Oracle{{cite web|url=https://www.orafaq.com/tools/heraut/dezign.htm|title=DeZign for Databases Review|author=Ashutosh Gaur|date=March 19, 2001|publisher=oraFAQ}}{{Cite book|url=https://www.editions-eyrolles.com/livre/sql-pour-oracle|title=SQL pour Oracle: Applications avec Java, PHP et XML - Optimisation des requêtes et schémas - Avec 50 exercices corrigés|author=Christian Soutou|date=May 7, 2015|publisher=Eyrolles|isbn=9782212320435|language=fr}}

, MySQL{{Cite book|url=https://books.google.com/books?id=Zg3E__FZilYC|title=Het beste van PHP en MySQL|author=Ward van der Put|date=2011-02-10|publisher=New Riders|isbn=9789043016636|pages=224|language=nl}}

, SQL Server, PostgreSQL, BigQuery, InterBase, SQLite.

Automatic foreign key migration
Presentation formats include HTML, RTF, MS Word, PDF, XML Schema, PNG, JPG Output
Bi-directional compare and synchronize functionality for all sync use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model{{Cite book|url=https://www.oreilly.com/library/view/database-administration-the/0201741296/|title=Database Administration: The Complete Guide to Practices and Procedures|author=Craig S. Mullins|date=June 2002|publisher=Addison-Wesley Professional|isbn=9780201741292|language=en}}
Subdiagrams management
Data model version control
File based and folder based projects (for storage in Version Control Systems such as Git)
Open file format (XML)
Generate database documentation

History

2024 - Google BigQuery support (Version 14.5)
2024 - Forward and reverse engineer Snowflake databases (Version 14.4)
2023 - Introducing folder based projects and GIT support (Version 14)
2022 - Extended data dictionary export capabilities (Version 13)
2020 - Introducing the start screen and a complete interface redesign (Version 12)
2019 - New subscription-based licensing model
2019 - Enrich data models with user defined properties (Version 11)
2017 - Labeling: Organize the objects in your model into meaningful groups (Version 10)
2015 - Support for Azure SQL (Version 9)
2014 - Team-based modeling collaboration capabilities with a central repository database (Version 8)
2012 - SQLite support and new code editor (Version 7)
2009 - Bi-directional compare and synchronize functionality for all sync use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model (Version 6){{cite web|url=https://www.postgresql.org/about/news/dezign-for-databases-v60-adds-support-for-bidirectional-synchronization-of-models-and-databases-1163/

|title=DeZign for Databases V6.0 Adds Support for Bidirectional Synchronization of Models and Databases|date=Nov 26, 2009|publisher=The PostgreSQL Global Development Group}}

2008 - Compare your data model to a live database and update your model (Version 5){{cite web|url=https://www.computable.nl/2008/01/25/product-dezign-for-databases-5-0/|title=Product: DeZign for Databases 5.0|author=Elmer Smaling|date=Jan 25, 2008|publisher=Computable}}
2004 - Integrated reverse engineering with native connections for MySQL, Oracle, MS SQL Server, PostgreSQL, InterBase and Firebird (Version 4)
2003 - Introducing several packages tailored to different professional needs: Standard, Professional and Expert.
2002 - SQL parser to import DDL files.
2001 - First modeling tool with MySQL support (forward and reverse engineering support) and company name change{{cite web|url=http://www.datanamic.com/company/press_new_company_name.html|title=HERAUT SOLUTIONS ANNOUNCES NEW COMPANY NAME AND NEW WEB SITE|author=Rick van Dijk|publisher=Datanamic|date=Apr 3, 2001|archive-url=https://web.archive.org/web/20010616182418/http://www.datanamic.com/company/press_new_company_name.html |archive-date=16 June 2001 }}
2000 - Reverse engineering capabilities with the ImportER add-ons.
2000 - The first commercial release of DeZign for Databases (Company name was Heraut Solutions) (Version 2){{cite web|url=http://www.heraut.demon.nl/newsarchive.html|title=Heraut Solutions News Archive|publisher=Heraut Solutions|date=Aug 18, 2000|archive-url=https://web.archive.org/web/20000818002503/http://www.heraut.demon.nl/newsarchive.html |archive-date=18 August 2000 }}