Software:DeZign for Databases

From HandWiki
DeZign for Databases
Original author(s)Datanamic
Stable release
14.6.2[1] / January 16, 2025; 54 days ago (2025-01-16)
Operating systemWindows
TypeDatabase design, Database modeling, development
Licenseproprietary
Websitewww.datanamic.com/dezign/

DeZign for Databases is a visual database design and modeling tool[2] 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[3][4]

, MySQL[5] , 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[6]
  • 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)[7]
  • 2008 - Compare your data model to a live database and update your model (Version 5)[8]
  • 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[9]
  • 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)[10]

Platforms

DeZign for Databases works on the Windows operating system.

Support

See also

References

  1. ↑ "DeZign for Databases version history". Datanamic. January 16, 2025. https://www.datanamic.com/dezign/versionhistory.html. Retrieved 2025-01-16. 
  2. ↑ Teorey, Toby J.; Lightstone, Sam S.; Nadeau, Tom; Jagadish, H. V. (Feb 10, 2011) (in en). Database Modeling and Design: Logical Design. Elsevier. pp. 234. ISBN 9780123820211. https://books.google.com/books?id=9x2LawVL_UsC. 
  3. ↑ Ashutosh Gaur (March 19, 2001). "DeZign for Databases Review". oraFAQ. https://www.orafaq.com/tools/heraut/dezign.htm. 
  4. ↑ Christian Soutou (May 7, 2015) (in fr). SQL pour Oracle: Applications avec Java, PHP et XML - Optimisation des requêtes et schémas - Avec 50 exercices corrigés. Eyrolles. ISBN 9782212320435. https://www.editions-eyrolles.com/livre/sql-pour-oracle. 
  5. ↑ Ward van der Put (2011-02-10) (in nl). Het beste van PHP en MySQL. New Riders. pp. 224. ISBN 9789043016636. https://books.google.com/books?id=Zg3E__FZilYC. 
  6. ↑ Craig S. Mullins (June 2002) (in en). Database Administration: The Complete Guide to Practices and Procedures. Addison-Wesley Professional. ISBN 9780201741292. https://www.oreilly.com/library/view/database-administration-the/0201741296/. 
  7. ↑ "DeZign for Databases V6.0 Adds Support for Bidirectional Synchronization of Models and Databases". The PostgreSQL Global Development Group. Nov 26, 2009. https://www.postgresql.org/about/news/dezign-for-databases-v60-adds-support-for-bidirectional-synchronization-of-models-and-databases-1163/. 
  8. ↑ Elmer Smaling (Jan 25, 2008). "Product: DeZign for Databases 5.0". Computable. https://www.computable.nl/2008/01/25/product-dezign-for-databases-5-0/. 
  9. ↑ Rick van Dijk (Apr 3, 2001). "HERAUT SOLUTIONS ANNOUNCES NEW COMPANY NAME AND NEW WEB SITE". Datanamic. http://www.datanamic.com/company/press_new_company_name.html. 
  10. ↑ "Heraut Solutions News Archive". Heraut Solutions. Aug 18, 2000. http://www.heraut.demon.nl/newsarchive.html. 
  11. ↑ Srinivas Rao, Koppula; Prasad, Munaga V. N. K.; Bapi, Raju Surampudi (November 4, 2018) (in en). First International Conference on Artificial Intelligence and Cognitive Computing AICC 2018. Springer Nature Singapore. ISBN 9789811315800. https://books.google.com/books?id=LWR2DwAAQBAJ. 

External links

This page will be placed in the following categories if it is moved to the Article namespace.
Categories:


Retrieved from "https://handwiki.org/wiki/index.php?title=Software:DeZign_for_Databases&oldid=3738841"