We have upgraded to SQL 2012 and Am trying to reverse engineer our Dbs into Visio 2010. I setup a connecting using SQL 11 driver and Visio complains that that driver is not supported.
Any one run into this?
Sql-server – Visio 2010 and SQL 2012 – Reverse Enginnering
database-designsql serversql-server-2012visio
Related Question
- Sql-server – Couldn’t install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1
- Sql-server – Use Older Versions Of SQL Server Databases With 2012
- Sql-server – SQL Server 2012 Publisher SQL Server 2008 Subscriber version issue
- Sql-server – Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010
- SQL Server – How to Reverse Engineer Database Diagram
- Sql-server – SQL Server 2012 Crashes and service doesn’t restart
- Sql-server – Cannot connect to local db
- Setting Up Reverse-Proxy for SQL Server on Linux with Docker
Best Answer
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.
I didn't need to do anything with the Advanced or All tabs after the connection succeeded, just clicked OK and was able to pick the object types and list of objects and it exported everything to the diagram.