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....
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.
