How to Move a Database Diagram in SQL Server 7.0 and 2000

SQL Add comments
After initially moving a database to it's demo environment - I found that I had to manually sync any diagram changes manually as ApexSQL didn't handle these. I found this article on the Microsoft KB which worked perfectly, allowing me to transfer the diagrams from dev: How to Move a Database Diagram in SQL Server 7.0 and 2000

Instructions

  1. Expand the Databases folder.
  2. Right-click the database that contains the diagram that you want to copy, click All Tasks, and then click Export Data
  3. In the Data Transformation Services Import/Export Wizard, click Next.
  4. On the Choose a Data Source page, click Next.
  5. On the Choose a Destination page, select the server and database to which you want to transfer the database diagram. Click Next.
  6. On the Specify Table Copy or Query page, click to select the Use a Query to specify the database to transfer check box, and then click Next.
  7. On the Type SQL Statement page, type the following line, and then click Next: select * from dtproperties
  8. On the Select Source Table and Views page, click the Results destination, and then change it to dtproperties. Click Next.
  9. On the Save, Schedule, and Replicate Package page, click to select the Run Immediately check box, and then click Next.
  10. On the Completing the DTS Import/Export Wizard page, click Finish.
  11. Click OK, and then click Done to exit the wizard.
Bookmark and Share

0 responses to “How to Move a Database Diagram in SQL Server 7.0 and 2000”

Leave a Reply

Leave this field empty:

Powered by Mango Blog. Design and Icons by N.Design Studio