Getting Started with Adeptia Data Migration Tool

PREREQUISITES 

The pre-requisites of using the Data Migration utility are outlined as:

• Java Runtime Environment (JRE) 1.6

• The database of the Adeptia Server should be running. In case of HSQLDB, you need to ensure that the
kernel is running, as it activates the backend database of the server. In other databases, the kernel is not
required to be running, however if it is running, it will not affect the migration utility.

• Ensure that no objects are created or modified during the Migration process

STARTING ADEPTIA DATA MIGRATION UTILITY 

You can run the Migration utility on:
• Server
• Desktop

The Migration utility is either bundled with Adeptia Server or it can be downloaded or purchased separately. To run it on a desktop, you need to copy the utility explicitly on the desktop.

It is recommended that you run the utility on the Adeptia Server, as some parts of the utility
can be run on the Server only.

When we run the utility, the system creates a log file in the same location as the utility file. Each time you run the utility; this log is appended. Data Migration Utility can be started in GUI Mode or in the Console mode.

Starting Data Migration Utility 

Steps to start the Data Migration Utility

1. To start migration utility bundled with Adeptia Suite, go to ./bin folder where Adeptia Suite is installed.
2. For Windows OS double click the MigrationUtility.exe file. The Adeptia Migration wizard is displayed

For Linux OS, type the following command:
./migrationutility.sh -console

3. Click Next. The following screen is displayed below.

4.Select the build environment and click Next. The Select Action screen is displayed

Note: Select the Standalone Build if the Adeptia Server is installed in standalone mode and select 

WebSphere Build in case the Adeptia Server is deployed on WebSphere Application Server. 

In case you are using Migration Utility for WebSphere build, you need to do some changes 

related to backend database in Server-Configure.Properties file. To know how to change 

Server-Configure.Properties file.

5. Select the appropriate radio button and click Next. The subsequent screens are displayed based on the selected  option. If you select Environment promotion option, refer to Environment Promotion section. If you select the  Migration option, refer to the Migration section. If you select the Patch Update, refer to the Patch section.  Starting Migration Utility in Console mode  Using Migration Utility in console mode is similar to that of using it in GUI mode with minor differences. Just the  initial startup is explained in this section.  Steps to start the Migration Utility in Console mode  

1. Open the command prompt and change to the Migration Utility folder. 

2. Run the following command to start it in console mode. The Migration Wizard starts (see Figure 1). 

java –jar Migration.jar -console 

3.Select the appropriate option to go to the next step. For example in the above screen, to select STANDALONE  BUILD, type 1 and press ENTER.

Benefits of Using Data Migration Software

The benefits of using the Data Migration software are outlined as:

• Provides an automated means of object transfer across environments and versions
• Provides options of transferring all objects or selected objects based on a group, objects within a group or
even fields within an object
• Maintains an Audit log of all actions performed in the object transfer
• Rollbacks the entire operation if an error occurs. If the migration is successful, it cannot be rolled back.
• Allows you to take a backup of all objects so that they can be restored whenever required.

Do You Need For Data Migration Software ?

At times while working with an Data Migration product, we may come across a situation, where we need to change a  process flow or an object. For this, we need to transfer the objects across multiple environments, such as change  the object in the Development environment, test it in the QA environment and finally apply the changes in the Production environment. Alternately, when an upgrade of an  product is released, you need to migrate all the data from the earlier version to the upgraded version. This can be quite a cumbersome process.

ADEPTIA  MIGRATION UTILITY :

Adeptia offers a Data Migration software which facilitates you to seamlessly migrate objects in all situations. It is a comprehensive data migration tool which enables you to:
• Promote objects across environments (for example, Development environment to QA environment, or QA
environment to Production environment)
• Migrate objects from an older version to a new upgraded version
• Change the backend database
• Take backup of the Adeptia Server
• Apply Accelerator

This data migration tool allows you to transfer objects in three ways:

• Environment Promotion: It allows you to promote objects across environments. This is migration at the
user level, where you can select a group and promote all its objects such as Events, Activities, Process
Flows, Users and Groups, to another environment. In environment promotion logs data and transaction
states are not transferred to new environment.

• Migration: It allows you to migrate objects across versions. This is migration at an advanced level, where
you can transfer all objects of all groups in the currently installed version to a new upgraded version.
Additionally, it also facilitates you to take a backup of all objects and configuration files in the current
installation and restore them whenever required.

• Patch Update: It allows you to update the patch over existing Adeptia Server. It replaces the files which
are in patch and change the backend database as per the query written in patch.

• Apply Accelerator: It allows you to apply the Accelerators. For example: Netsuite, Salesforce and EDI

Accelerators.