Microsoft Visio Database add-in - Reverse Engineer of Azure Sql Server only showing master Database and no others

0 votes

I'm trying to target one of our databases that is an Azure SQL Database using the Visio Reverse Engineer wizard, which is a feature of the Visio database add-in.

The same connection strings I use for all of our other services, including SSMS, SSIS, Python, etc., allow me to connect successfully. However, the only DB option it offers me is "master" Master DB only Option. Once connected, it only shows objects from the master database, which is obviously not a data model that I'm trying to reverse engineer. available master DB objects

I've also tried using the 'Catalog=' Parameter to point to the relevant database, but this only gives me the same choices.

Our entire collection of Azure SQL databases has a connection string. database.windows.net

For our other SQL Server, which is on an Azure VM rather than an Azure SQL Database itself, I've used the Reverse Engineer wizard before with no issues.

I'm not sure at this time whether this is a problem with the Visio Reverse Engineer wizard or if there is a setting that we are missing with our Azure SQL Databases.

I sincerely appreciate any assistance.

Thanks!

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
526 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Azure

0 votes
0 answers

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
438 views
0 votes
1 answer

Where is the output of Azure SQL Database Auditing Stored?

1. Azure SQL Database Auditing Overview: Azure SQL ...READ MORE

answered Oct 18, 2023 in Azure by anonymous
• 3,360 points
590 views
0 votes
1 answer

Test environment for microsoft graph api and Azure v2.0

Yes, the type of application you register ...READ MORE

answered Mar 2, 2022 in Azure by Edureka
• 12,690 points
755 views
0 votes
1 answer

How to add Azure Portal to myapps.microsoft.com

Steps to add Azure Portal: Sign in as an ...READ MORE

answered Mar 8, 2022 in Azure by Edureka
• 13,620 points

edited Jun 27, 2023 by Khan Sarfaraz 2,405 views
0 votes
1 answer

Difference between Image , VHD and Snapshot in Azure

Is Image the same as the VHD ...READ MORE

answered Mar 24, 2022 in Azure by Edureka
• 12,690 points
1,481 views
0 votes
0 answers

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

I'm trying to reverse-engineer an Azure SQL ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
524 views
0 votes
0 answers
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

A SQL Server database table has had ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
679 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,620 points
787 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP