2
Thanks

A few words of thanks would be greatly appreciated.

How to Import or Export Diagrams With SQL Server

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a database, the dtproperties table will have to be imported or exported too. Configuration is done automatically in the source database but has to be done manually in the destination database. Read on to find out how to perform this task.


How to Import or Export Diagrams With SQL Server

Information about the diagrams is stored in the dtproperties table. Basically to import or export a diagram, you simply need to import or export the dtproperties table.
Follow the below procedure:
  • 1 - Right click on the database containing the diagrams. Click on All Tasks then on "Export data".
  • 2- The Import / Export option will be displayed, click Next.
  • 3- Define the source and then click Next. Normally the configuration is done automatically.
  • 4- Configure the destination database and click Next.
  • 5- In the "Specify Copy or Query Table..." section , click Use a query to specify a data transfer, then click Next.
  • 6- On the Enter the SQL statement, type the following line:" Select * From dtproperties " then click Next.
  • 7- On the Select all tables and sources, choose the dtproperties table in the destination column and then click Next.
  • 8- Click on "Run immediately", then click Next and finally click Finish.


Image: ©123RF.com
2
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « How to Import or Export Diagrams With SQL Server », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

3 Comments