Make a Copy of a Mining Model
Applies To: SQL Server 2016
Creating a copy of a mining model is useful when you want to quickly create several mining models that are based on the same data. After you copy the model, you can then edit the new copy by changing parameters or adding a filter.
For example, if you have a Customers table that is linked to a table of purchases, you could create copies to generate separate mining models for each customer demographic, filtering on attributes such as age or region.
For information about how to copy the content of the model (such as the graphical representation or the model patterns) to the Clipboard for use in other programs, see Copy a View of a Mining Model.
In SQL Server Data Tools (SSDT), in Solution Explorer, click the mining structure that contains the mining model.
Click the Mining Models tab.
Select the model, and right-click to open the shortcut menu.
Select the model. On the Mining Model menu, select New Mining Model.
Type a name for the new mining model, and select an algorithm. Click OK.
Select the mining model.
In the Properties window, click the text box for the Filter property, and the click the build (…) button.
Change the filter conditions.
For more information about how to use the filter editor dialog boxes, see Apply a Filter to a Mining Model.
In the Properties window, in the AlgorithmParameters text box, click Setalgorithm parameters, and change algorithm parameters, if desired.