Extracts a mining model or mining structure object from the server to an Analysis Services backup file.
You must be a database or server administrator to export or import data mining objects.
For backward compatibility, the default filename extension for the backup file is .abf; however, you can use any filename extension that you want. Note, however, that the format of the file is internal to Analysis Services, and the file cannot be read or edited regardless of which extension you use.
OLAP mining models have complex dependencies and cannot be exported by using the EXPORT command.
The following example exports the Targeted Mailing and Forecasting mining structures, together with 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 the keyword MINING MODEL.
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 uses the keyword, WITH DEPENDENCIES, the data source and data source view objects are also included in the backup file.
EXPORT MINING MODEL [Association] TO 'C:\Association_NEW.abf' WITH DEPENDENCIES
The following example exports the Call Center mining model to the specified file location, and uses a password to protect the model. Because the statement uses the keyword, PASSWORD, you must supply the specified password when you import the backup file or the model cannot be created.
EXPORT MINING MODEL [Call Center_LR] TO 'C:\Temp\ExportedModels\CallCenterPrediction.abf' WITH DEPENDENCIES, PASSWORD='CCLR2%'