Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
Reverse engineering with Visio 2013 on a SQL Server 2012 DB

Answered Reverse engineering with Visio 2013 on a SQL Server 2012 DB

  • mercredi 5 décembre 2012 11:29
     
     
    Connectez-vous pour voter
    0

    Hello, 

    Am I correct in my opinion that the reverse engineering functionality is dropped in Visio 2013? Please tell me I'm wrong and how I should do it...

    When using Visio 2010 to reverse enigineer a SQL Server 2012 db, I discovered that certain data types were not shown right in my data model. The data type 'time(0)' was translated to 'image' when using the odbc generic driver and it was translated to 'text' when using the generic oledb driver. Choosing the SQL Server driver returned an error telling that the driver is not compatible with Visio. 

    So I was pleased with the release of Visio 2013 because it came later than SQL Server 2012 and I thought they should be compatible now. Is this correct and how should I perform reverse engineer? 

     

Toutes les réponses

  • mercredi 5 décembre 2012 12:54
     
     Traitée
    Connectez-vous pour voter
    0

    You are not incorrect, it was dropped in v2013.

    al

    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Al Edlund Visio MVP

     
  • lundi 10 décembre 2012 12:28
     
     
    Connectez-vous pour voter
    0

    Reverse engineering is not possible in Visio 2013?? WHY???

    Is MS hoping that someone makes an add in for this functionality?

    I evaluated Visio 2013 and it was a big disappointment because this is from my point of view a crucial functionality.

     
  • mardi 11 décembre 2012 02:14
    Modérateur
     
     Traitée
    Connectez-vous pour voter
    0

    Hi,

    Visio still has various database diagramming options and these can be bound to data. Access can bind to ODBC datasources and can link tables - these can be also be graphically visualized.

    Full-on reverse engineering functionality is now provided by Visual Studio in the Premium or Ultimate editions.

    There is a helpful white paper for VS 2010 here: http://go.microsoft.com/?linkid=9768309

    Note that this doesn't provide a visualization (the SQL Workbench have this capability) but does provide access to the schema & data in a way that makes database developers very productive.

    Jaynet Zhang
    TechNet Community Support

     
  • lundi 11 mars 2013 16:14
     
     
    Connectez-vous pour voter
    0

    @Jaynet

    what is "the SQL Workbench"?  It would be appreciated if you would provide a link to this toolset, please.


    Also, for general information, there's a long discussion on this topic on linked in on the Microsoft Business Intelligence thread.  It is called "One good reason not to upgrade to Visio 2013: Database tools are dead and gone".

    Cheers, Donna

    Donna Kelly

     
  • mardi 12 mars 2013 12:33
     
     Réponse proposée
    Connectez-vous pour voter
    1

    I suspect it was the MYSql workbench

    http://dev.mysql.com/downloads/workbench/

    al

    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Al Edlund Visio MVP

    • Proposé comme réponse Donna Kelly mardi 12 mars 2013 14:10
    •  
     
  • mardi 12 mars 2013 14:12
     
     
    Connectez-vous pour voter
    0

    Al, this is extremely helpful, especially given that MySql Workbench is available under GPL.

    I would never have guessed My SQL :-)

    Thank you very much, Donna

    Donna Kelly