Sunday, March 25, 2012

exporting diagrams

is there any way to export database diagrams from one copy of a database to
another?
same database - different location.
for some reason the diagrams didn't get restored or maybe backed up so the
are not available.the1.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 dtproperties8.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.
be sure to get dbo's copy of dtproperties and refresh the diagrams windows
after.

No comments:

Post a Comment