MS Visio Professional generation SQL

Source: Internet
Author: User
Tags xslt

Visio supports database modeling, but the Professional version does not include the forward engineering function, that is, SQL cannot be generated. This is really annoying. Fortunately, there are tools like orthogonaltoolbox. This is a very interesting software. After installation, it does notProgramMenu item, cannot be started directly, but adds a toolbar to other applications.

You can open a database model created by visio in orthogonaltoolbox, export it to XML, and select "er to SQL XSLT transform" as the style. Then open the XML in IE to see the SQLCode.

This XSLT is designed for ms SQL Server, but it is easy to modify it to generate SQL statements for other databases, or it is also a good idea to replace regular expressions directly in the generated SQL text.

Http://blog.csdn.net/pinxue/archive/2006/10/05/1322090.aspx

 

 

Installation instructions
To install orthogonal toolbox:

    1. download the ZIP file and extract the contents of the ZIP file to any (temporary) location.
    2. Run (START | run... Then browse... To the extract location) setup.exe.
    3. follow the instructions of the installation utility.
    4. once installation is complete, you can access orthogonal toolbox by opening/Creating An ORM source model and/or a database model dimo-within Visio.
    5. look for the toolbar titled "orthogonal toolbox". If the toolbar is not visible, it can be made visible via View | toolbars | orthogonal toolbox.
    6. once the toolbar is visible, you can use the utility by clicking the button labeled "orthogonal toolbox".

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.