Have Geek Brain

SQL - SSMS2005 - How to copy a database diagram to another database?

Is there an easy way to copy a database diagram from one database server to another?

I have a diagram on a development server that needs to be migrated to a production server.

thanks

(Sql server 2005, SSMS2005 Express)

+2


a source to share


2 answers


In SQL Server 2005, database diagrams are stored in the sysdiagrams table. You can use the Import / Export Wizard to copy chart data from one server to another. I did a quick test and was able to copy a diagram from one database to another from the same server using a wizard. This has been tested on a SQL Server 2005 Standard installation.



+2


a source


you can try codeproject Script SQL Server 2005 Diagrams to file



+4


a source






More articles:


All Articles