Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
Applies to: 
SQL Server 2019 and earlier Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Important
Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.
This article describes how to create a new data mining project by importing the metadata from an existing data mining project on another server. Use the template Import from Server (Multidimensional and Data Mining) Project in SQL Server Data Tools.
Import data sources, mining structures, and mining models from an existing data mining project
When you use the template Import from Server (Multidimensional and Data Mining) Project, SQL Server Data Tools creates a new data mining project and then copies the metadata from the specified data mining project. The new project contains the same data sources, data source views, mining structures, and mining models as the database you imported from. However, you can't use the project until you update certain properties and process the objects as described in this article.
The import process doesn't copy the data itself from the source server to the new data mining project. The process imports only the definitions of the data sources and data source views. After the import process completes and creates the objects, you must populate the objects with data by training the mining structures and dependent models. You can use the command Process All in Data Mining Designer to train the models and structures.
If you're importing a project that you created in a previous version of SQL Server Analysis Services, the data source might use providers that aren't installed on the server you're importing the project to. If you encounter errors when processing the imported mining structures, right-click each data source and select Open Designer to edit the connection string and review the provider properties.
At this time, you might also need to verify that the account you're using to process the data mining objects or query data mining models has the necessary permissions on the data source.
By default, when you import a project, the workspace database is set to localhost, or whatever default instance is configured as the Default Target Server in SQL Server Data Tools. To set this property, from the Options menu, select Business Intelligence Designers, select Analysis Services, and then select General.
In SQL Server 2017, you can set another, separate option to configure the default deployment server for SQL Server Analysis Services tabular model projects. The setting, Default Deployment Server, determines the default workspace database for tabular model projects. You can't use instances that support tabular models for data mining projects.
If you can't change the default deployment database to use an instance of SQL Server Analysis Services running in multidimensional or data mining mode, you can always specify the deployment database by using the Project Properties dialog box.
To create a new data mining project by importing an existing data mining project
In SQL Server Data Tools, on the File menu, select New and then select Project.
In the New Project dialog box, under Installed Templates, select Business Intelligence > Analysis Services and then select Import from Server (Multidimensional/Data Mining).
For Name, type a name for the project, specify a location and solution name, and then select OK.
The Import Analysis Services Database wizard starts. Select OK on the Welcome page to proceed.
On the Select Source Database page, for Server, specify the SQL Server Analysis Services instance that contains the solution you want to import.
For Database, choose the SQL Server Analysis Services database that contains the data mining objects you want to import, and then select Next.
Important
You can't specify the objects you want to import. When you choose an existing SQL Server Analysis Services database, the wizard imports all multidimensional and data mining objects.
The Completing the Wizard page displays the progress of the import operation. You can't cancel the operation or change the objects being imported. Select Finish when done.
The new project automatically opens in SQL Server Data Tools.