• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • VRA makes the case for Prudential
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • My session and other Visio sessions at MSIgnite 2019
    • Innovative uses of Visio Lists
    • Vision up your Visio diagrams
    • Power up your Visio diagrams
    • Mastering Data Visualization with Microsoft Visio
    • Microsoft Visio Business Process Diagramming and Validation
    • The Visio 2010 MVP Sessions
    • Visualizing Information with Microsoft Visio
    • Visio Web Learning Resources
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • Visio blog on Orbus website
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Ariba Network

DBRE

Published on December 12, 2016 by David Parker

Reverse Engineering SQL Server DBs with Visio Pro DBRE

The news is out: due to popular demand DBRE (Database Reverse Engineering) is [almost] back in Visio. It is currently out in preview, as announced in MS Power User , for Visio Pro for Office365 users at least. It is, however, only providing support for MS SQL Server and Oracle Server, although there is an ODBC Generic Driver too.
My test machine is a Surface Pro 1, which does not have SQL Server installed, so my instinct was to test DBRE with a SQL Azure database that I created for my eXplore Visio app  ( see Windows Store ).



Try as I might, I could not get the full database structure with the Microsoft SQL Server driver that I had installed by default. With a little help from Microsoft, I discovered that I needed to download the Microsoft ODBC Driver 13 for SQL Server from Microsoft ( see Download Driver). However, I still needed to set the default database for Visio to use as Microsoft SQL Server, not ODBC Generic Driver. In retrospect, it makes sense, but it did confuse me for a while.
Once I understood that, I was able to change my default database to the desired visioFeatures one, and to reverse engineer my SQL Azure database tables, views and stored procedures.

[Read more…] about Reverse Engineering SQL Server DBs with Visio Pro DBRE

Filed Under: Office 365, SQL Server, Visio 2016, Visio Pro for Office365 Tagged With: DBRE, SQL, Viso Pro for Office365

Primary Sidebar

Recent Posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Categories

Tags

Accessibility Add-Ins Connectors Data Export Data Graphics Data Import DataRecordset Data Visualizer Educational Excel FM GraphDatabase Hyperlinks Icons Icon Sets JavaScript Layers Legend Link Data to Shapes Macros MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Scales Shape Data ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Validation VBA Video Visio Visio 2007 Visio 2013 Visio Pro for Office365 Visio Services Visio Viewer Web Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

Search this website

Recent posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Copyright © 2019 · Executive Pro on Genesis Framework · WordPress · Log in