MSSQL export to visio

how to export schema database from MSSQL to Visio?

open visio application.

1. on visio application choose File -> new -> Database -> Database Model Diagram.
2. Menubar choose Database -> Reverse Engineer Wizard
   Installed Visio drivers : Microsoft SQL Server
   Data sources : New…
   1. System Data Source and Next.
   2. SQL Server and Next.
   3. Finish.
   4. on “Create a New Data Source to SQL Server” insert name, description and SQL Server to connect.
      ( Example SQL Server : p1kae\SQLEXPRESS )
   5. choose “With SQL Server authentication using a login…”
   6. insert Login Id and Password.
   7. check “Change the default database to:” and use database name to export .. Next.
   8. Finish.
   9. OK.
3. ok now we have Data sources and choose
   Datasource : [Datasource Name]
   and Next.
4. Confirm user and password.
5. choose object types and next.
6. Next algorithm (: P) and Finish.

ok. u can import database schema from MSSQL to Visio.

Tags: MSSQL, Visio