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

    Question

  • 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? 

    mercredi 5 décembre 2012 11:29

Réponses

  • 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

    mardi 11 décembre 2012 02:14
    Modérateur
  • 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

    mercredi 5 décembre 2012 12:54

Toutes les réponses

  • 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

    mercredi 5 décembre 2012 12:54
  • 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.

    lundi 10 décembre 2012 12:28
  • 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

    mardi 11 décembre 2012 02:14
    Modérateur
  • @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

    lundi 11 mars 2013 16:14
  • 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 12:33
  • 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


    mardi 12 mars 2013 14:12
  • That's a lot of bafflegab.  Can you try to provide an honest straight-up answer instead of over-adjectivized marketing nonsense?

    Fact - MSFT has dropped ER diagramming from Visio in the sense that one can connect to SQL Server and reverse engineer the diagram from the database.

    Fact - MSFT VS "may" be able to do some facsimile of a database diagram (I say may because despite the assertions of many MSFT posts, blogs, forum responses, etc. I have not been able to accomplish this mystical feat).

    Fact - If one is a database developer, or works for a company that purports to support database development, then one knows perfectly well what 'reverse engineer a database diagram' means.

    It means you connect to a server, you connect to a database, you define what attributes you want included in the ER diagram, such as PK to FK relationships, indexes, etc. You click OK, and you get an ENTITY RELATIONSHIP DIAGRAM; one that you can then export to other tools and/or print to a printer.

    Embarcadero does provide this.  ERwin does this.  Microsoft DOES NOT PROVIDE THIS at anywhere near the degree of competence it wants people to believe it does.

    And that's the real mystery here.  We have a company that has an awesome database product in SQL Server.
    It has dominant position in office productivity tools with Office.  It has Visual Studio.  And yet in this product portfolio that has existed for well on 2 decades there is this gap in designing database diagrams that is so wide a gulf that anyone who works in the database development world can see it.

    And yet Microsoft persists in this party line of providing 'visualizations' and schema compares, and such.

    Just don't waste your time on trying to explain to Microsoft that they have a hole in their product line up.
    They know that they do.  You cannot be as good at developing SQL Server as they are and NOT know it.

    They cannot, more likely will not address this feature set... not in SQL Server, not in Visual Studio, and not in Office.

    Therefore just read the tea leaves and move on.  Buy Embarcadero.  That is what we have done in our Data Warehouse Team at the company I work for.  We need productive solutions, we cannot afford to dink around with the tinker toys Microsoft has decided to provide for database modeling.

    I've used ERwin in the past and it too is a great product.

    I'd have more respect for Microsoft if they would just come out and say point blank what they telegraph in their products - 'we don't have a product in this space and don't intend to field one'.

    mardi 6 août 2013 11:44
  • That stinks! I bought Visio Pro just for the database diagramming capabilities. It seems Microsoft is determined to cripple all of its software.
    mardi 6 août 2013 19:07
  • Actually, Randy, it's worse than you described.

    You said "Microsoft persists in this party line of providing 'visualizations' ".

    But Jaynet said: "Note that this *doesn't* provide a visualization "

    Me?  I really don't like any of the 2013 product set.  Not Visual Studio, not Office, not SharePoint, and especially not Windows Server 2012.  Whoever thought of sticking a touch screen UX on a Server product ought to be shot.

    I'm sticking with 2010 as long as I can.

    (I do like Denali though!).


    Donna Kelly



    mardi 6 août 2013 21:24
  • You know, Irene, back in the day, Visio would do forward engineering out-of-the-box, as well.

    But then the asteroid hit . . . 


    Donna Kelly

    mardi 6 août 2013 21:26
  • Let me be the voice of your Visio users......

    WHOMEVER decided to drop the database reverse engineering feature from Visio at Microsoft SHOULD BE FIRED!!!! Take his/her keyboard away, now!!!

    That was a fantastic feature. It kept me out of Erwin and validated the spend on Visio.... I guess here is one more reason not to Enterprise buy Visio...

    Poll your Enterprise users before you drop functionality!

    jeudi 21 novembre 2013 17:47
  • That is not an answer. At best, that "answer" is disingenuous.

    Say it like it is: It's dead, Jim.

    And there goes the last reason I ever had to use Visio. It used to be a good product.


    See my blog: http://boffincentral.com/blog

    mardi 11 février 2014 01:53
  • Thanks. That's exactly what I needed to know. Would that the MS rep had been so straightforward.

    Keep in mind that Microsoft did not create Visio. They bought it and have been trying to retrofit it ever since. I see less and less capability from a professional perspective.

    Thanks again for a direct answer.

    lundi 3 mars 2014 20:26
  • I remember that, too. At least on the enterprise version.  Sigh.
    lundi 3 mars 2014 20:27