Post reply

Database Modeling

  • May 17, 2010 at 7:37 pm

    #386947

    I have built a database and wanted to verify that it has no obvious errors in the design.

    previously i have used visio 2003 to reverse engineer it and get it to find any errors.

    However, visio 2003 has issues reading sql 2005 database. While to upgrade to visio 2007 requires different versions visual studio and once you have visual studio 2008 then no version of visio is compatible 100%

    Is there any tool out there that I could use to verify my database model. Is there something in Visual studio 2008 or some add on or free product that will pick up errors in my model ..eg no primary key, incompatible datatypes etc etc.

    regards

    Erick

  • May 18, 2010 at 6:10 am

    #1168739

    Best tool I know of for working with models is Embarcadero ERStudio.

    But if you do a search, there are free ones out there, but you're going to get what you pay for.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 26, 2017 at 3:26 am

    #1956967

    You will need to export your database schema as a SQL script, and then run these scripts in MSSQL Studio orSSDT (SQL Server Developer Tools) to generate the XML database-creationscripts. After that, simply upload the XML statements into SQLDBM, and thencreate your physical model or ERD

    There are many tools that can help you out. Most of them require payment or a monthlyfee, but there are also free ones:

    DbDesigner.net

    • Pricing: Free basic version; paid version starting at $50/year
    • Supported DB products: Model and generate SQL for MySQL, SQLite, SQL Server, PostgreSQL, Oracle
    • Supported browsers: Not specified
    • Reverse engineering: Import SQL from MySQL (feature described as “experimental”)

    Vertabelo

    • Pricing: Free basic version; free academic version; advanced version available for a monthly subscription starting at $9/month or on a per-use basis starting at about $1/day; in-house installation starting at $1399 for a one-time license fee
    • Supported DB products: Model and generate SQL for PostgreSQL 9.x, Oracle Database 11g, MySQL 5.5, SQLite 3.7.x, DB2 9.7, SQL Server 2012, HSQLDB 2.3; also export model as XML
    • Supported browsers: Chrome, Safari (beta)
    • Reverse engineering: Free tool available; can also import directly from an SQL or XML file

    SQLDbm

    • Pricing: Free
    • Forward engineering: Use SQLDBM to create a physical model or ERD of your database
    • Reverse engineering: Use the reverse engineering feature to export your database schema as a SQL script

    Features:

    • Create database objects like tables, objects, relationships, indexes, quickly and intuitively
    • Alter and edit database objects inline in your diagram
    • Copy or Move columns across tables
    • Zoom in and out of diagrams
    • On-the- spot design anywhere on any browser

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply