Post reply

How to develop a db diagram with Crow's Foot notation for 2014/2016?

  • February 21, 2016 at 1:09 pm

    #311594

    Used to be that you could use Visio Pro 2010 to reverse engineer an SQL Server database and create a database diagram that uses the Crow's Foot notation. I have Visio Pro 2010 but it no longer seems to read 2014 and 2016 databases. Newer releases of Visio don't seem to have support for reverse engineering anymore. How can I create a diagram for a 2014 or a 2016 database automatically (reverse engineer) that uses the Crow's Foot notation?

    Thank you.

  • February 22, 2016 at 4:06 pm

    #1860227

    I don't suppose you could set the COMPAT level temporarily down to the value for SQL 2012 or SQL 2008, and then backup the data, restore it to an available test instance of SQL 2012 or 2008, and then use the tool on that temporary copy? Alternately, script out all the tables and apply the script to a test instance of 2008 or 2012 and do the same....

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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