Hot answers tagged visio
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, ...
The Generic OleDB Driver also works for reverse engineering a SQL Server 2012 database using Visio 2010. (Might not be "supported", but this works). Select the Generic OLE DB Provider from the list of Installed Visio drivers and click Next. Then pick the Microsoft OLD DB Provider for SQL Server and then go to the Connection tab. Enter in your server ...
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.
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
You can use Small Time Stamp (auto)
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 ...
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.
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?
Only top voted, non community-wiki answers of a minimum length are eligible