Visio 2010 Reverse Engineering Display Data Types
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.
Jess
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.
Jess
try to follow these instructions fro the below article link
Reverse Engineering a SQL Server Database using Visio
http://social.technet.microsoft.com/wiki/contents/articles/25701.reverse-engineering-a-sql-server-database-using-visio.aspx
Reverse Engineering a SQL Server Database using Visio
http://social.technet.microsoft.com/wiki/contents/articles/25701.reverse-engineering-a-sql-server-database-using-visio.aspx
ASKER
Eugene: Thanks for your reply.
I've been using the instructions as Eugene suggested and it all comes up as shown in the article.
One thing I discovered was using the Display Options.
Under Table -> Data Types -> Show Physical. This allows the datatypes to show.
Now the definitions are coming up wrong.
If I choose a table -> look at properties -> choose Columns -> Edit -> Data Type -> Make a change and click OK - the change doesn't stick.
Vitor: Thanks for your help.
I set up a driver thru C:\Windows\SysWOW64\wowreg
I've been using the instructions as Eugene suggested and it all comes up as shown in the article.
One thing I discovered was using the Display Options.
Under Table -> Data Types -> Show Physical. This allows the datatypes to show.
Now the definitions are coming up wrong.
If I choose a table -> look at properties -> choose Columns -> Edit -> Data Type -> Make a change and click OK - the change doesn't stick.
Vitor: Thanks for your help.
I set up a driver thru C:\Windows\SysWOW64\wowreg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is the issue causing the problem. What my employer has decided is to give me a new computer with Windows 8 64 bit and Software of 32 bit.
Check which one Vision is using. Maybe it using the wrong one.