CODEWITHSUNDEEP
sqlimportvisio
SUN Jiangong
SUN Jiangong

Reputation: 5312

How to import mysql sql file into microsoft visio 2007?

Does anyone know how to import a mysql sql file into microsoft visio 2007, and then generate a database chart automatically?

Thanks a lot.

Upvotes: 3

Views: 5849

Answers (1)

SUN Jiangong
SUN Jiangong

Reputation: 5312

I have solved it.

I just create database in mysql with sql file, and then i use reverse engineering to build a visio chart.

the link will be useful for that. here

[EDIT]: Add The content of the post.

1.Download the latest MySQL ODBC connector from MySQL site. You may find it here http://dev.mysql.com/downloads/connector/odbc/5.1.html.

  1. After downloading install the connector.
  2. Now open Microsoft Visio and open Database Model Diagram template (you may find it under Software and Database group).
  3. From Database menu click on Reverse Engineer. You will see the Reverse Engineer wizard.
  4. Click on the New button.
  5. Select System Data Source.
  6. Click Next.
  7. Select MySQL ODBC driver from the list.
  8. Click Next and then Finish. MySQL Connector/ODBC Data Source Configuration window will open.
  9. Give a name to the datasouce, database server host, user name, password and select the database you want to reverse engineer. Remember, the list of database will be shown if you have provided correct information.
  10. Click on Ok. Now you will find the data source in Data Source list.
  11. Select the newly created data source and click Next. The regular wizard for reverse engineering will start.

Thanks.

Upvotes: 2

Related Questions