IMPORT (DMX)

Loads a mining model or mining structure from an Analysis Services backup file onto the server.

Syntax

IMPORT FROM <filename>

Arguments

• filename
  A string containing the name and location of the backup file to import.

Remarks

If no objects are specified, the entire contents of the backup file will be loaded. If the backup file includes a database that does not exist on the server, the database will be created.

You must be a database or server administrator to export or import objects.

Import from File Example

The following example imports the definition of the association model and its underlying structure onto the current server.

IMPORT FROM 'C:\TEMP\Association_NEW.abf'

See Also

Reference

Data Mining Extensions (DMX) Data Definition Statements

Data Mining Extensions (DMX) Data Manipulation Statements

Data Mining Extensions (DMX) Statement Reference

EXPORT (DMX)

Concepts

Exporting and Importing Data Mining Projects (Analysis Services - Data Mining)

Change History

Updated content
Corrected syntax of IMPORT statements.
Updated example to use the same extension as in the EXPORT (DMX) topic..
Removed most references to the .abf file extension, which is not required for data mining backup files.