none
Unable to see MySQL triggers, views and stored procedures from Visio 2019 RRS feed

  • Question

  • Hi Team,

    I would like to use Visio 2019 as a primary modeling solution (I'm currently using Visual Paradigm)

    In Visio 2019, it seems possible to connect to MySQL Database.

    Unfortunately, i only see tables, index and foreign keys but unable to load MySQL views, triggers and stored procedures.

    This is what i've been done at this time:

    1/ Install latest 64 bits MySQL ODBC driver (version 8.00.16.00)

    2/ create a user DSN to my MySQL database stored in Azure

    3/ Connect to the database via ODBC in Visio 2019

    Next step, decide which types of objects i need to import:

    As you can see: views, triggers and stored procedures are greyed out.

    Any idea how to solve this issue ?

    For your records, everything is working well with other diagram solutions like Visual Paradigm or MySQL Workbench.

    Any help would be greatly appreciated

    Thanks in advance

    Phil

    Wednesday, June 12, 2019 4:47 PM

Answers

  • Hi Phil,

    According to the article Reverse engineer an existing database into a database model, the Reverse Engineer Wizard isn't available in Visio 2013/2016/2019. There may be some limits in it.

    To help you better resolve the issue, I suggest you give feedback on Visio or ask question on Microsoft Community for help.

    If you have any updates, feel free to post back to let us know.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, June 13, 2019 8:28 AM
    Moderator
  • Hi,

    This thread has been around for a long time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

    Thank you for understanding! 

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.


    Friday, July 5, 2019 1:13 AM
    Moderator

All replies

  • Hi Phil,

    According to the article Reverse engineer an existing database into a database model, the Reverse Engineer Wizard isn't available in Visio 2013/2016/2019. There may be some limits in it.

    To help you better resolve the issue, I suggest you give feedback on Visio or ask question on Microsoft Community for help.

    If you have any updates, feel free to post back to let us know.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, June 13, 2019 8:28 AM
    Moderator
  • Hi,

    I am checking the status of this issue. Do you have any update for it?

    If my reply is helpful to this question, please remember to mark it as answer. Your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding.

    Anything unclear or any questions, feel free to post them back to let us know. I will be glad to follow up and help you.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.


    Tuesday, June 18, 2019 12:59 AM
    Moderator
  • Hi, 

    I decided to keep my existing UML software (Visual Paradigm)

    Visio 2019 is not what i'm looking for in a professional UML environnment.

    Thanks anyway...

    Tuesday, June 18, 2019 6:01 AM
  • Hi,

    Thanks for your response. I need your help now. Please remember to mark my reply as answer. It will benefit all community members who are facing similar issues. Your contribution is highly appreciated. 

    Thanks for your kind understanding.

    Best Regards,

    Herb 


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019. 

    Tuesday, June 18, 2019 7:01 AM
    Moderator
  • Hi,

    This thread has been around for a long time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

    Thank you for understanding! 

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.


    Friday, July 5, 2019 1:13 AM
    Moderator