This Visio add-in for Database Modeling lets you create a database model from an existing database. Of course, we originally had forward engineering too, and I often designed a prototype in Microsoft Access, sucked it into Visio, edited the schema in Visio . In your database model diagram, on the Database tab, click Reverse Engineer. On the first screen of the Reverse Engineer Wizard, do the.
DEFAULT
DEFAULT
Download Visio Add-in for Database Modeling from Official Microsoft Download Center
Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It only takes a minute to sign up.
Connect and share knowledge within a single location that is structured and easy to search. Up until a few years ago I used Microsoft Visio to reverse engineer an existing database to a diagram.
This feature has been deprecated for a while now, and I'm rather stuck in finding an alternative. Most of these requirements were in Visio, though not all of them. I guess finding one piece of software that has them all is not feasible, but I'd like to get close. Incremental update , e. Pretty diagrams modern look and feel, anti-aliasing, choice of fonts, colors, gradients, drop shadows, theming, etc ;.
Friendly learning curve I can handle many complex features as long as it's easy to get the basics done quickly ;. Of course this question has been asked before, even on sister sites with some success even though they're off topic there. Here's a few:. Good tool to visualise database schema? Anyone know of a decent free DB schema reverse engineering tool? Furthermore, Wikipedia has a table comparing several software packages for "reverse engineering" feature:. Visio this is what I used to use.
Not free, outdated, but otherwise it fit the bill for most points. Not an option anymore though. Visio and this is what I have currently. Reverse engineering is no longer supported. I've considered writing a plugin or using VBA to hack things together though. Not sure how tough that would be.
It's not free except I guess that I personally have it already , but fits the bill on a lot of other points. Tried this quite some time ago, from what I remember it had a bit steep learning curve and I wasn't quite able to manually determine final layout. SSMS diagrams. This works for small cases, but can be cumbersome for larger cases. Visual Studio ADO.
Manual layouting of connectors is limited, theming does not exist at all, it is really meant for a goal other than documentation and it shows e. This may be useful for smaller scenario's but doesn't fit the bill for me. And I think I may have tried a few suggestions from the SO threads, though I can't really remember specifics. Here's a recommendation I ended up using after a lot more research and trying many different options :.
There is no tool that conveniently satisfies all mentioned requirements, not even one that fulfills the main requirements only. Visual Studio comes close, but lacks theming support and didn't work very well for a large number of tables. Create a blank Visio Flowchart 1 template.
Choose a design you like. Set the page and print sizes to something you want I chose landscape A3 format and the "Linear" theme. Start adding the tables one by one. Choose manually which tables and columns you which to include. As a bottom line, I do recommend this approach, mainly because you end up with a visually appealing model and a high degree of control.
This approach doesn't fit the entire bill though. Here's how it holds up to the requirements:. I haven't looked into this though as I have Visio. I've also tried the UML template and shapes but this has infuriating behavior for connector routing.
Not recommended! It can connect to pretty much database that you can configure a JDBC connector for, and it can do all the reverse engineering that you are looking for. SchemaCrawler is a free, open-source database discovery tool that can reverse engineer your existing database. I just had the same requirements as the original question, but Visio already had an advantage for our choice as the ERD diagrams were once generated via reverse-engineering in Since, we already have Office subscription Visio Pro was added to it, which gave me Visio 16 released end of Then, we installed Database Modeling add-in for Visio to reverse engineer our database.
Your list of requirements is fully covered by Lucidchart. Well, it's not free, but it has a free trial. With Lucidchart you run a query that they specify, then import the query results.
This creates a collection of tables that you can drop onto a diagram like stencil shapes. Lucidchart draws the connections between the keys of the tables you've chosen. You can rearrange the tables and connections, remove fields, change colors and fonts, etc.
And no worries about typos. The downside is that this isn't a live connection to your database, so to refresh you'll need to do some manual work. Cons: Misses linked keys. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Start collaborating and sharing organizational knowledge. Create a free Team Why Teams? Learn more about Teams.
Asked 8 years, 5 months ago. Modified 1 year, 8 months ago. Viewed 28k times. Pretty diagrams modern look and feel, anti-aliasing, choice of fonts, colors, gradients, drop shadows, theming, etc ; Friendly learning curve I can handle many complex features as long as it's easy to get the basics done quickly ; MUST HAVE: Installer doesn't secretly install toolbars in my browser or change my home page! Here's a few: Good tool to visualise database schema?
SE: How do you document your databases? So: what would you recommend? Improve this question. Community Bot 1. Jeroen Jeroen 1, 1 1 gold badge 16 16 silver badges 32 32 bronze badges. Add a comment. Sorted by: Reset to default. Highest score default Date modified newest first Date created oldest first. Here's a recommendation I ended up using after a lot more research and trying many different options : Use plain Visio for this.
Here's why. Explanation of this approach: There is no tool that conveniently satisfies all mentioned requirements, not even one that fulfills the main requirements only. The following process worked for me: Create a blank Visio Flowchart 1 template.
Separators aren't lines but just a series of bold — dashes after eachother. White for TableName and separators, black for column names. In addition, I chose for foreign keys to: Never allow crossing connectors, and instead creating small "reference" blocks that refer to a table that's somewhere on the other side of the model.
Not include all tables i. Hopefully the above will be of use to others too. Requirements from the question: As a bottom line, I do recommend this approach, mainly because you end up with a visually appealing model and a high degree of control.
So "more or less". Control and visuals: Manual layouting, basic theming, able to choose which items to show Able to handle complex models, e. Bonus Points: It has about half of the bonus points: runs on Windows 8 SQL also supported pretty friendly learning curve 1. Improve this answer.
How did you go about "adding" the tables from queries in SSMS? Does Visio have a way to accept a query? Are you saying you just created the diagram manually? The full version from the thumbnail picture took me about 3 hours of work, total. Keeping it up to date is about 10 mins per 4-week sprint. Until someone comes up with a good alternative highly welcome! I'll likely stick with this "solution". Also, I think " Powerpoint works just as well " doesn't trivially follow from the premise Rest assured though that I was not happy that Visio is the least-bad-option.
DEFAULT
DEFAULT
Microsoft visio 2016 reverse engineering database diagram free
Go to File -> New -> Database -> Database Model Diagram. On the menu bar, choose Database -> Reverse Engineer. A Reverse Engineer Wizard will appear. Choose Oracle Server for the Installed Visio Driver. Click on 'Setup' and check on Microsoft ODBC for Oracle. On the Data Sources, click on 'New'. Select 'User Data Source'. Click on 'Next' and select a driver. . Oct 03, · Visio pro isn't allowing reverse engineer of database. I just bought Visio Professional for the purposes of reverse engineering a database. I have gone to File -> New -> Software -> Database Model Diagram and chose the crow's feet type. There's no Database tab like older versions had, and the closest thing I found was under Data -> Custom . Reverse engineer an existing database. In your database model diagram, on the Database tab, click Reverse Engineer. On the first screen of the Reverse Engineer Wizard, do the following: Select the Microsoft Visio database driver for your database management system (DBMS).
DEFAULT
DEFAULT
DEFAULT
DEFAULT
2 comment