Varigence, Inc.

Mist provides an import capability. This allows you to pull existing schema and table definitions from a database into your model. These items are then imported as new objects in the model. Once imported, you can edit them as needed.

To import database assets, you first need to create a connection to the database. See Creating a Connection for more information. Then, you then need to create a database asset. See Creating a Database for more information. Once done, you can perform an import using the following steps:

1. Select the Home tab on the ribbon.
2. Click the Import Tables button.
   
3. Select the connection to use for importing (AdventureWorksLT in this example). The connection state indicator will turn green to indicate a good connection.
4. Also select the project database to import the schemas and tables into (AdventureWorksLTDatabase in this example).
   
5. Select the schemas and tables that you would like to import. For this example, all schemas and tables should be selected.
6. Click OK to begin the import.
7. When it completes, save the project to persist your changes.

Once the import is complete, there will be 15 tables under the Tables folder in the logical view, as well as 2 schemas under the Schema folder.

If you would prefer to import tables as live objects (that update the model with the current state of the table in the database at each compile), see the Importing Tables using BimlScript topic.