Hot answers tagged visio
The Generic OleDB Driver also works for reverse engineering a SQL Server 2012 database using Visio 2010.
I cannot test it from here, but I would try using the SQL 10 driver if you can. They usually have high level of compatibility across versions. Or else try using the Generic ODBC driver. That almost always works, though you don't always get as much with it.
All you need is configured ODBC connection to Oracle DB 1. Install Oracle Client SW (download from otn.oracle.com). I recommend installing same version as your Oracle DB 2. Define connection in tnsnames.ora 3. Create and test ODBC connection to Oracle DB in Control Panel > Administrative Tools > Data Sources (ODBC) - use Oracle's driver in your ORA_HOME, ...
What you need is "Microsoft® ODBC Driver 11 for SQL Server® - Windows" which can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?id=36434
The first, you should read the NORMALIZATION concepts (1NF,2NF,3NF,...) after that you can use them to verify your dependency diagram. So, I'm talking about some basic steps to help you convert ERD, which I often do: 1- Identify objects (objects are WHO, WHERE, WHAT, WHEN ), you imagine that they are exited and can be defined. 2- Identify natural keys of ...
I'd check out Embarcadero tools Try Data Architect.
You can't do that in Visio. However, you can reverse engineer a database using Visio. The answer to the question below should help you. How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?
You can use the "free" MySQL workbench if you are using MySQL https://www.mysql.com/products/workbench/ to reverse engineer the model from an SQL file then re-organize the model into multiple pages.
Only top voted, non community-wiki answers of a minimum length are eligible