import-dmx.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
IMPORT (DMX)	IMPORT (DMX)	minewiskan	owend	owend	02/17/2022	sql	analysis-services	reference	dmx

IMPORT (DMX)

[!INCLUDEssas]

Loads a mining model or mining structure from an Analysis Services Backup File (.abf) file onto the server.

Syntax

  
IMPORT FROM <filename>  

Arguments

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

Remarks

If no objects are specified, the entire contents of the .dmb file will be loaded. If the .dmb 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 entire contents of the file containing the association model and structure onto the current server.

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

See Also

Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference
EXPORT (DMX)
Export and Import Data Mining Objects