Import a ER diagram in Gliffy

Question

I have a SQL Database. I would create an ER diagram in Gliffy (site). Gliffy only imports files from Microsoft Visio. So I don't how to export my DB from SQL Server in Visio to create the diagram there and importing the same into Gliffy.

Any ideas? There are other tools I can use to do this?

score 2 · Accepted Answer · answered Dec 19 '13 at 02:08

2

Visio professional (except Visio 2013) has a "reverse engineer" feature. You can use it to create a diagram of your existing SQL Server database. See here for example:

Reverse engineering an existing database

Reverse and forward engineering databases in Visio 2010

answered Dec 19 '13 at 02:08

Nikolay

10,752
2
23
51

I'm trying with visio professional... The second link don't work for me. The plugin is not working with Win7 32 bit. There's a workaround, but it doesn't work anyway. – sharkbait Dec 19 '13 at 09:24
1

Here is the link to official docs for 2010: http://office.microsoft.com/en-us/visio-help/reverse-engineer-an-existing-database-into-a-database-model-HA101818235.aspx. You may be facing a known problem with SQL SERVER 2008, please take a look here: http://stackoverflow.com/questions/92811/reverse-engineering-for-database-diagramming-in-visio-with-sql-server-2008 – Nikolay Dec 19 '13 at 12:38

score 1 · Answer 2 · answered Dec 25 '13 at 12:09

1

First import the SQL schema from DB to Visio. Then export the file and import in Gliffy.

That's all.

answered Dec 25 '13 at 12:09

sharkbait

2,980
16
51
89

From Visio to Gliffy I can only export/import an image file... i thinked I can export a file editable from Gliffy... – sharkbait Jan 10 '14 at 09:43

Import a ER diagram in Gliffy

2 Answers2