Applies to: SQL Server Analysis Services
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]
Optional.The type of the object to export (either mining model or mining structure).
Optional. The name of the object to export.
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 Analysis Services database.
Export Mining Structure Example
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'
Export Mining Model Example
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
Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference
Export and Import Data Mining Objects