Pre-Migration Tasks

For information about the pre-migration tasks that you must perform, see Performing Pre-migration Tasks in SAS Intelligence Platform: Migration Guide. Here are the most important steps:

Back up your SAS system, including servers and desktop clients.
Back up the SAS Decision Manager Common Server database if you are migrating from SAS Decision Manager 2.2 to 2.2 on a SAS 9.4 system.
Perform any required maintenance that is required to meet minimum baselines.
Use a custom deployment plan to install SAS 9.4 and SAS Decision Manager. You must specify the plan file when you use the SAS Deployment Wizard.
Complete the pre-installation and migration checklists. These checklists can be customized based on the deployment plan that you choose. For more information, see Completing the Pre-migration Checklists in SAS Intelligence Platform: Migration Guide.
If you are moving to a new system, ensure that the required operating system user accounts that you used for SAS in your current operating system also exist in your new operating system. Examples of these user accounts include sasadm, sastrust, and sasdemo. The migration process requires the same operating system user accounts that you used with your current operating system.
Before you migrate to SAS Decision Manager 2.2, you should record the database settings in your current environment. You must enter this information in SAS Deployment Wizard.
- For the SAS Decision Manager Common Data Server, record the database name and the user name for your database. The default database name is dcmdb.
- If you are using Oracle for your database, record the following information:
  
  fully qualified host name of the database server
  
  port number of the database server
  
  Oracle Site Identifier (SID)
  
  user ID of the database user whose credentials are used to access SAS Decision Manager data on the server
  
  password of the database user whose credentials are used to access SAS Decision Manager data on the server
  
  You can find the Oracle SID in the tnsnames.ora file. You can also determine the SID by running the following query using a database user ID on your Oracle instance:
  select instance from v$thread
  You must enter the SID in the Database name field in the SAS Decision Manager Database JDBC Properties dialog box in SAS Deployment Wizard.
Install third-party software. If you are using Oracle for your database, ensure that the Oracle client is installed on your server tier and that there is a matching tnsnames.ora file for the SAS Decision Manager Common Data Server database. See SAS Deployment Wizard Information for Oracle for information about the tnsnames.ora file.
Create a SAS Software Depot. For more information, see Creating SAS Software Depots in SAS Intelligence Platform: Migration Guide.

Use the SAS Migration Utility to create a migration package.You must enter the configuration properties for the SAS Model Manager Mid-Tier (MMAPI) database management system in the SAS Migration Utility properties file.

The values for the SAS Migration Utility properties can be found in SAS Management Console. Select the Folders tab and expand System

Applications

SAS Model Manager Mid-Tier. Select the Model Manager Mid-Tier <version> folder, right-click the Model Manager-Mid-Tier <version> application object, and then select Properties

Configuration. The prefix for the configuration properties that are equivalent to the SAS Migration Utility properties is dbms.mmapi.

Here is the list of configuration properties that should be used to populate the migration properties:

SAS Migration Utility Properties	Configuration Properties in SAS Management Console
mmapi.data.dbms.type	dbms.mmapi.type
mmapi.dbms.data.name	dbms.mmapi.name
SMU.mmapi.dbms.host	dbms.mmapi.host
SMU.mmapi.dbms.port	dbms.mmapi.port
SMU.mmapi.dbms.userid	dbms.mmapi.userid
SMU.mmapi.dbms.password	<not stored here>

For more information, see SAS Migration Utility Reference in SAS Intelligence Platform: Migration Guide, and SAS Model Manager Properties in SAS Intelligence Platform: Migration Guide.