Moving Prediction Models to an External Database

  • Article

If necessary, you can move your prediction models to an external database instead of to a file. This option is not recommended for performance reasons, however, the steps for moving the prediction model to an external database are provided in this topic.

On the Data Warehouse computer, you first create a new SQL Server Copy DTS package to move the Predictor tables and data to the external database. Next you update your site pages to add calls to the PredictorClient object to retrieve the data for display.

Ee825021.note(en-US,CS.20).gifNote

  • To move a prediction model using a Copy DTS package, you must open port 1433 on the firewall between the Web server and the Data Warehouse server. For detailed instructions about configuring ports and firewalls for a secure deployment, see Deploying a Secure Site.

To create a new SQL Server Copy DTS package

  1. On the Data Warehouse computer, open SQL Enterprise Manager.

  2. Navigate to the local SQL databases, and open the Data Warehouse database, for example, <sitename>_dw.

  3. Right-click Tables, click All Tasks, and then click Export Data.

    The Data Transformation Services Import/Export Wizard is started.

  4. On the Choose a Data Source dialog box, accept the local database (for example, <sitename>_dw) as the source, and then click Next.

  5. On the Choose a destination dialog box, select the external database as the destination, and then click Next.

  6. On the Specify Table Copy or Query dialog box, select Copy tables and views from the source database, and then click Next.

  7. On the Select Source Tables and Views dialog box, select the following tables, and then click Next:

    • [<sitename>_dw].[dbo].[PredictorDataTables]
    • [<sitename>_dw].[dbo].[PredictorModelCfgs]
    • [<sitename>_dw].[dbo].[PredictorModels]

  8. On the Save, schedule, and replicate package dialog box, schedule the package to run each time after model refresh intervals.

    For information about setting up the model refresh intervals, see Step 2: Set the Refresh Interval for the Prediction Model.

  9. Click Finish.

Copyright © 2005 Microsoft Corporation.
All rights reserved.