Oracle Migration Tool On Demand Guide > Migrating Access Profiles > Migrating Access Profiles >

Updating or Inserting an Access Profile (Upsert)

This topic describes how to update a specific access profile (if it exists), or insert that access profile (if it does not exist) on your Oracle CRM On Demand environment (customer test environment or production). For the purposes of the Oracle Migration Tool On Demand client, this is known as an Upsert operation. This operation is specified using the Upsert command.

An update to an access profile is derived from the access profile system name. That is, if you run an Upsert operation on an access profile where the access profile system name in the XML file is My Access Profile, and an access profile of the same name exists in the target company, then the target access profile is updated. If the access profile does not exist on the target company, then the access profile is inserted on the target. The matching of the access profile name is also case sensitive. For example, if the access profile system name in the XML file is MY Access Profile and the target access profile is My Access Profile (no uppercase Y), then the MY Access Profile access profile is inserted in the target.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update a specific access profile (if it exists) or insert the access profile (if it does not exist):

migrationtool -u UserID -s ServerURL Upsert AccessProfile AccessProfileXML 

where:

• UserID is the user sign-in ID that has the appropriate privileges to run the Oracle Migration Tool On Demand client commands.
• ServerURL is the URL for the Oracle CRM On Demand server where your company resides.
• AccessProfileXML is the fully qualified path name of the access profile XML file, for example:

  C:\My Files\My Profile.xml

The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (using the pipe command) to the client program from standard input; that is, from a file, from the command line, or from another program.

Example of Updating or Inserting an Access Profile

The following is an example of updating a specific access profile (if it exists) or inserting that access profile (if it does not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL Upsert AccessProfile "C:\My Files\My Profile.xml"

NOTE:  Quotation marks are required only if the path or file name contains spaces.