Revit Export model data to SQL Server database

Revit software can export model data to SQL Server database, sometimes, in order to do data analysis of the model, you need to export the data of the model, the following summarizes the export process:

First set up a database in SQL Server, such as: Revit_wujinqian

First step: Revit Click Export-ODBC Database

Step Two: Machine data source-new

Step three: User data source (select System data source also)--Next

Fourth step: SQL Server Native Client 11.0 (10.0 Also, I am revit2017 here, so chose 11.0)-Next

Fifth Step: Complete

Sixth step: Custom Name (M) (such as: Revitwujinqian) server (S) (Click the drop-down arrow, select your SQL Server location, if locally, select Local, sometimes drop-down loading slow, you can also directly fill in the column "(local)", Remember to bring the parentheses), fill in the completed, next

Seventh step: There are two choices, select any one can

1. Integrated Windows authentication (W) SPN (optional) (P) fill in the database password

2. SQL Server authentication using user input login ID and password (S)

Login ID (L): Fill in your own database user name

Password (P): Fill in the password corresponding to the user name

Complete the next step after completing

Eighth step: Select Change the default database to (D) Click the drop-down arrow on the right in the input box below, select the database you created earlier and click Next

Nineth Step: Select Done

Tenth step: Create complete, in the Machine data source list can see the account you just created, check click OK

11th Step: Server SPN (V) fill in the database password click OK

12th Step: Revit Export data Start, at the bottom left of Revit there will be a progress display, and so on when the export is complete, open the Data view, the data table is as follows

Note:

1, it is possible to open a database without data, this time need to refresh to show

2. Different Revit projects, there are differences in the exported data tables

Reprint please indicate the source

Revit Export model data to SQL Server database