![]() However, even after having the ODBC and OLE DB drivers on the machine, I am not able to use them appropriately. I've used the Reverse Engineer wizard before for our other SQL Server (which is on an Azure VM and not a Azure SQL Database itself) with no problems.Īt this point, I'm not sure if this is an issue with the Visio Reverse Engineer wizard or if there is some setting that we are missing with our Azure SQL Databases. 5,277 5 32 62 Add a comment 4 Answers Sorted by: 8 The database reverse engineering code was removed in Visio Professional 2016 because of some issues, but it was announced late last year that it will be returning this year. I have a SQL Server 2019 installed on my local and I am trying to reverse engineer one of the databases to work with the database model in Visio Plan 2. in my MS Visio Professional 2019 distribution I cannot find the database tab. ![]() Master DB objects availableĪdditionally, I've tried passing 'Catalog=' Parameter to point to the database in question but this gives me the same options.Īll of our Azure SQL Databases have the connection string. No Database Tab /Reverse Engineering in MS Visio Professional. One connected it displays only objects in the master db which obviously I'm not trying to reverse engineer into a data model. I'm able to successfully connect using the same connection strings that I use for all of our other services, SSMS, SSIS, Python, etc., however the only DB option it gives me is 'master' Master DB only Option. I'm attempting to use the Visio Reverse Engineer wizard, part of the database add-in for Visio, targeting one of our databases that's an Azure SQL Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |