export data from a VISIO ER diagram to SQL server

[Rania Aouad]

I normally do all my DB design through the SQL server "database diagram"
interface. A developer recently handed me a VISIO with about 40 tables. I
have heard that there is a way I can take this VISIO document and connect it
to the test database then push the new tables to SQL server.

If this is true, please help me figure it out. I have looked up "Reverse
Engineer" in the Visio help menu, but that shows me how to take data FROM SQL
server to VISIO. I need to push data FROM VISIO to SQL server.

There are currently no objects in the TEST database, so I want to connect
this VISIO to the blank DB and then have the software create all the tables
in the new blank DB.

Please help....

 

[Nikolay Belyh]

You need "Visio Enterprise Architect" edition to be able to do that
(it is shipped with Visual Studio, for example).

If you don't have it installed then you can ask your developer to hand
you an SQL script for database generation instead of that diagram (EA
edition is also capable of generating SQL scripts)

Kind regards, Nikolay.