Post reply

URGENT, Generate DB Diagram in visio from SQLServer!

  • October 5, 2011 at 1:02 am

    #248889

    hi folks,

    i want to generate a database diagram in visio of a sql server DB. how to do it if any body have any idea.

    i have a DB in a different server and i want to generate a DB diagram of that and take a printout, i installed visio 2010 in my local machine but unable to import the DB and generate the diagram.

    any help will highly appreciated.

  • October 5, 2011 at 1:51 am

    #1390525

    Hi,

    1. Open Visio 2010 with credentials that is able to connect to the database.

    2. Select the Database diagram template.

    3. Go to the database tab and select reverse engineer.

    From there on it's a straight forward data source connection set up.

    Regards...

  • October 5, 2011 at 3:58 am

    #1390561

    Thanks dude,

    i got it, as i was new to visio i was found it little confusing.

    the steps i follow i am mentioning here, it might help somebody else.

    visio

    1) open a new file as database template

    File -> New -> Database and Software.

    2) Go to Database tab in file menu click on reverse engineer

    3) In reverse engineer wizard select install visio driver as Microsoft sql server (as i want to import data from sql server, you can choose other sources also).

    4) Create a data source for your database, initially it will not be there you have to create it.

    New -> select type of data source (as file/user) -> select sql server -> give the data source name and description.

    5) click next

    6) give data source credentials(username/password).

    7) select the object types which you want to do reverse engineering,

    here you can select all or those which one you need

    8)complete all the list as it comes for tables,procedures, etc etc.(i have selected only tables)

    then click finish

    it will generate the diagram of all tables with PK,FK,Indexes

    from there you can manipulate the diagram as you want and can save it in different format like jpeg,pdf you can take print also

    cheers!!!

  • October 5, 2011 at 5:54 am

    #1390608

    If you want to do the exact contrary, check out this Visio Addin by SQL Server MVP Alberto Ferrari: http://forwardengineer.codeplex.com/

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply