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

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