Export (0) Print
Expand All

EXPORT (DMX)

Extracts a mining model or mining structure object from the server to an Analysis Services Backup File (.abf).


EXPORT <object type> <object name>[, <object name>] [<object type> <object name>[, <object name] ] TO <filename> [WITH DEPENDENCIES]

object type

Optional. The type of the object to export (either mining model or mining structure).

object name

Optional. The name of the object to export.

filename

The name and location of the file to export as a string.

If the statement specifies a mining model, the resultant file will also contain an associated mining structure. If the statement specifies WITH DEPENDENCIES, all objects required to process the object (for example, the data source and data source view) are included in the .abf file.

You must be a database or server administrator to export or import objects from a Microsoft SQL Server 2005 Analysis Services (SSAS) database.

The following example exports the Targeted Mailing and Forecasting mining structures, and the Association mining model to a specific file location. Because the Association model is part of the Market Basket mining structure, the example also exports the Market Basket structure. Any other mining models that may exist as part of the Market Basket mining structure will not be exported because the Association model was exported using MINING MODEL, not MINING STRUCTURE.

EXPORT MINING STRUCTURE [Targeted Mailing], [Forecasting] MINING MODEL Association TO 'C:\TM_NEW.abf'

The following example exports the Association mining model to a specified file location. Because the statement specifies WITH DEPENDENCIES, the data source and data source view objects are also included in the .abf file.

EXPORT MINING MODEL [Association] TO 'C:\Association_NEW.abf' WITH DEPENDENCIES

Community Additions

ADD
Show:
© 2014 Microsoft