Visio 2010 Reverse Engineering Display Data Types
Posted on 2014-09-10
Can you reverse engineer SQL tables and display the data type using Visio 2010?
This is what I'm doing now:
Click on File - Software & Database - Database Model Diagram - Create
Click on Database - Reverse Engineer - Generic OLE DB Provider
Select SQL Server Native Client 10.0 - Next - enter servername, windws NT, database name- OK
Get msg The default driver was changed to Generic OLEDB provider.
Uncheck Stored procedures - Next - Choose my tables - Next - Next - Finish
** When I click on reverse engineering and have to select a driver - with Microsoft SQL Server -
I can create a new datasource but it never shows up in the list under Microsoft SQL Server.
It shows up under ODBC.
Also - the my computer is a 64 bit machine and the software is 32 bit.