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!