March 25, 2012 at 11:43 am
Have there been improvements with the Database Diagram Tool?
If you have to restore a Database and how can you preserve your diagram?
Can you export & import?
I seem to recall that there are some Stored Procedures that facilitate this?
Can I export and load into Visio to create a reversed engineered diagram?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2012 at 12:51 pm
Welsh Corgi (3/25/2012)
Have there been improvements with the Database Diagram Tool?
No, it's still just as useless as it always was.
Can I export and load into Visio to create a reversed engineered diagram?
You can reverse engineer a database in Visio and you don't need the SQL Server Diagram Tool to do that. Create a database model diagram and click Reverse Engineer on the Database tab. The database diagram features of Visio haven't been upgraded are still pretty limited though. The forward engineering features were removed so you have to install Visio 2003 Enterprise Architects to do that.
March 25, 2012 at 1:03 pm
I'm using Visio 2010.
I liked the 2003 version better.
I did not find the 2010 very intuitive, change page layout, add/remove table from diagram, etc.
I'm pretty sure that that there are SP's to export/import into various formats.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply