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


IMPORT FROM <filename>


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


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'

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.