I typically make a Visio database model diagram, doing a reverse engineer feature. My issue now is that I have Visio 2010, but I need a model for a database on a 2014 server. It seems the Visio driver in 2010 is not compatible for SQL Server 2014 database connections.
I tried the generic ODBC connection, but it doesn't show all the fields in each of the tables.
I researched this, and it seems they discontinued reverse engineering SQL databases into models in Visio, after 2013. I made a SQL diagram, but it's a horrible interface, and I can't get a good visualization of the flow of data, like I can with Visio.
Anyone have any ideas for how I can get a good data model of this database, being that it's on a 2014 server?
Thanks!