This topic has not yet been rated - Rate this topic

IMPORT (DMX)

SQL Server 2008

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


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'

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD