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:
- Right click on the database containing the diagrams. Click on All Tasks then on "Export data".
- The Import / Export option will be displayed, click Next.
- Define the source and then click Next. Normally the configuration is done automatically.
- Configure the destination database and click Next.
- In the "Specify Copy or Query Table..." section , click Use a query to specify a data transfer, then click Next.
- On the Enter the SQL statement, type the following line:" Select * From dtproperties " then click Next.
- On the Select all tables and sources, choose the dtproperties table in the destination column and then click Next.
- Click on "Run immediately", then click Next and finally click Finish.
Need more help with programs? Check out our forum!
Subject
Replies
sound device
27
Programming
- Export diagram sql server
- Export database diagram sql server
- How to export database diagram from sql server
- How to make database connectivity in asp.net? [solved] > Forum - Programming
- How to avoid duplicate records in SQL: select query > Guide
- Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy > Guide
- Partitioning a Hard Drive for Mac, Windows, and Linux
- Restoring Project 2013 with only the SQL server component [solved] > Forum - Network
- Change Notepad++ background and foreground colors, dark mode
- Document list panel on Notepad++ is missing: how to enable?
- 64 bit integers: C++, example
- Java Servlet Development Kit (JDSK) installation
- PHP IP address of a visitor
- Move files older than X days: Windows 11,10,8,7