How can the SQL SERVERW Database Model diagram be converted to Ord-you can also view the attribute information field

Source: Internet
Author: User
Tags ord

1. In the SQL Server database, create a Database model diagram--DB diagrams

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvamn4nta4mzc2mq==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

2. Control Panel--Administrative Tools--ODBC Data Source link--Create a data source link for SQL Server

3. Open the Visio tool. Open the Database model--database--reverse engineer[Reverse Project]

Select the tables you want to import into Visio:

4. Import the table structure of DB into Visio, the interface may need to be slightly adjusted

Ability to view specific information about a field in Visio

Save Visio as a file.

5. Open Word, Insert Object

When you import a Visio file into Word, you can double-click the imported picture to see the specific information for each field in the table.

When someone looks at this word document, it is assumed that Visio is installed to see the specific information for the field.

It is also possible to copy a picture directly from database diagrams or from Visio to Word, but you cannot see the details of the field. Just a simple picture.

Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.

How can the SQL SERVERW Database Model diagram be converted to Ord-you can also view the attribute information field

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.