How to convert a model diagram in a SQL Server database into Word--and be able to view property information for a field

Source: Internet
Author: User

1. Model diagram for creating a database in a SQL Server database--database diagrams

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

3. Open the Visio tool to open the database model--database--reverse engineer[reverse engineering]

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

You can view the details of a field in Visio

Save Visio as a file.

5. Open Word, Insert Object

After you import a Visio file into Word, you can double-click the imported picture to see the details of each field in the table.

When someone looks at this Word document, you can view the details of the field if you have Visio installed.

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

Related Article

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.