All geek questions in one place

What tool can help create a SQL Server 2005/2008 database from an ER chart?

In Visio 2003 Architect, I can generate a SQL Server database on the fly with an UML ER diagram. But there is no such way using Visio 2007. My question is: can any other good and latest tools support ER-> DB or DB-> ER is very good for SQL2005 / 2008?

+3
source share
5 answers

If you are looking for a free open source tool for this, you can try:

DBDesigner

From the website:

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single seamless environment.

, .

DBDesigner 4 , Oracle Designer ©, IBM Rational Rose ©, Computer Associates ERwin © Kompany DataArchitect ©, , Microsoft Windows © 2k/XP Linux KDE/Gnome. GPL.

:

  • Linux/MS Windows
  • /
  • MySQL, Oracle, MSSQL ODBC
  • MySQL
  • ,
  • /
  • *
  • SQL Query Builder
  • SQL
  • SQL

, ( ) , (.. /).

, ER. , , , - (, , , ), , , .

+1

, Enterprise Architect .

http://www.sparxsystems.com.au/

+2

ER Visual Studio, dbml, Sql script huagati. http://www.huagati.com/dbmltools/

+2

, Visio 2003 , Enterprise Edition. 2007 ?

0

Most tools do not correctly handle SQL 2005/2008. But CA ERwin® Process Modeler does a better job (albeit at a cost).

There is a community version , but it is limited to 25 objects per model.

Try it and let us know.

0
source

Source: https://habr.com/ru/post/1712378/

More articles:


All Articles