LogoLogo
  • Welcome
  • Overview
    • Architecture
      • API Server
      • Sizing
    • Dashboard Overview
    • Monitoring Concepts
      • Application Performance Management
        • Availability Monitoring
        • Performance Intelligence
        • Service Level Management
        • Synthetic Transaction Management
        • Alerts Management
        • Reporting & Analytics
      • Infrastructure Monitoring
      • Unified Monitoring
    • Automation Concepts
      • Definition of Terms
      • Infrastructure as Code
        • Project Structure and Organization
        • Setting Up IaC Environment
        • Infrastructure Provisioning
        • Configuration Management
      • SAP Basis Automation
      • Automated Migration
  • User Guide
    • Onboarding
    • Setup
      • Gateway Setup
        • Gateway Network Setup
        • IT-Conductor Gateway Setup on Windows
        • IT-Conductor Gateway Setup on Linux
        • IT-Conductor Gateway Setup on AWS
        • IT-Conductor Gateway Setup on Azure
        • IT-Conductor Gateway Setup for SAP Secure Network Communications (SNC)
      • API Server Setup
      • MSP Tenant Setup
      • SSO Setup
        • Azure ADFS Identity Provider
        • Azure Active Directory (AAD) App Gallery
    • Monitoring
      • General
        • Maintenance Mode
          • Manual Maintenance
          • Scheduled Maintenance
        • Central Syslog Server Monitoring
        • URL Monitoring Locations
      • Cloud Monitoring
        • AWS Monitoring
        • Microsoft Azure Monitoring
      • Database Monitoring
        • IBM DB2 Database Monitoring
        • Microsoft SQL Server Monitoring
        • Oracle Database Monitoring
        • SAP HANA System Monitoring
          • SAP HANA Scale-Out Monitoring
          • SAP HANA Overview Dashboard
          • SAP HANA Alert Management
        • SAP ASE Database Monitoring
        • SAP MaxDB Monitoring
        • HA/DR Monitoring
      • Infrastructure Monitoring
        • File Server Monitoring
          • File Watcher Monitoring
        • Git Server
        • OS Monitoring
          • Unix/Linux System Monitoring
            • Linux Network Interface Monitoring
            • OS Printer Monitoring
          • Windows System Monitoring
            • WinRM Adapter Configuration
              • WinRM Services Configuration
              • Domain User Access
              • WMI Namespace Access
              • Windows Service Configuration
        • VMWare vCenter Monitoring
      • SAP Monitoring
        • Business Process Monitoring
          • Business Process Composer
          • BDoc Monitoring
          • IDoc Monitoring
        • SAP BusinessObjects Monitoring
          • SAP BO Data Services Monitoring
        • SAP Cloud Connector Monitoring
        • SAP Host Agent Monitoring
        • SAP NetWeaver Monitoring
          • SAP ABAP System Monitoring
            • SAP Transports
            • Security Role Import
            • SAP ABAP Overview Dashboard
            • SAP CCMS Alert Monitoring
            • SAP Batch Jobs Monitoring
              • SAP Batch Job Monitoring for CCMS Alerts
              • Advanced SAP Batch Job Monitoring
            • SAP SLT & RFC Connection Monitoring
            • Print Spooler Monitoring
            • Workload Monitoring
              • Transaction Code Monitoring
              • SAP Workload Monitoring
          • SAP J2EE System Monitoring
            • SAP J2EE Monitoring Role
            • Keystore Views and Certificates Monitoring
            • SAP PO Application Monitoring
          • SAP Systems Administrator Panel
        • SAP Web Dispatcher Monitoring
        • LMDB Discovery
        • Team-Based Central SAP Download Manager
    • Automation
      • Migration
        • Oracle to AWS Migration
        • Oracle to ASE Migration
        • SAP on MSSQL to AWS Migration
        • S/4HANA to Cloud Migration
      • E2E System Refresh Automation
        • Frequently Asked Questions
      • Age-based HANA Backup Automation
      • Inbound/Outbound Queue Restart Automation
      • OS File System Cleanup Automation
      • OS Linux Pacemaker Cluster Error Management
      • OS Printer Queue Restart Automation
      • OS Linux Kernel Patching using ChAI
      • OS Linux System Reboot using ChAI
      • SAP Batch Job Restart on Error
      • SAP Kernel Update using ChAI
      • SAP HANA Account Activation using ChAI
      • SAP Transports using ChAI
        • Frequently Asked Questions
      • SAP User Unlock and Password Reset Automation
      • Start/Stop Automation
    • Reporting
      • Available Reports
      • Creating Reports
        • Service Health KPI Report
      • Scheduling Reports
        • Automated HANA Reports
      • Report Elements
      • Archived Alerts Reporting
    • Account Administration
      • Invite Users
      • Create Robot Users
      • Update Linux System Account Password After Expiration
    • Notifications
      • Alerts
      • Threshold Overrides
        • Threshold Overrides Variables
      • Notification Targets
      • Distribution Lists
      • Subscriptions
      • Custom SMTP Notification Providers
      • Integration Providers
        • Derdack EA Integration
        • ilert Integration
        • Jira Service Desk Integration
        • Microsoft Teams Integration
        • PagerDuty Integration
        • Slack Integration
      • On-Call Scheduling
      • Calendar Events
    • Diagnostics
      • Gateway Communication Dump Debug Mode
      • Running IT-Conductor Gateway from CLI
      • SAP CCMS Missing Data
    • IT-Conductor FLUX
    • SID-Refresh
      • Product Overview
      • Getting Started
      • Documentation
      • Release Notes
      • Frequently Asked Questions
      • Troubleshooting Guide
        • Component CRM_MIDDLEWA_CRM - CRM Middleware Configuration
        • Failure to Start the Java-based GUI
        • Inconsistencies found in the table TADIR
        • Java-based GUI Runs with Pixelated Fonts
        • No email message is created after sending an email in SO01
        • Program Run as root
        • SICF Wrong Credentials
        • SU01: Error in user management
        • External Resources
      • Pricing
  • Release Notes
    • Gateway
  • References
    • Open-Source Software
    • Support
Powered by GitBook
On this page
  • Scenario
  • Process Definitions
  • SAP on Azure Migration Dashboard
  1. User Guide
  2. Automation
  3. Migration

Oracle to ASE Migration

PreviousOracle to AWS MigrationNextSAP on MSSQL to AWS Migration

Last updated 1 year ago

Migrating an Oracle database to an ASE (Sybase) database can be challenging, but having the right tools and procedures in place can ensure an efficient and smooth transition. In IT-Conductor, this can be accomplished using a process definition that consists of Terraform and Ansible activities developed to simplify the migration process.

Scenario

In this demo scenario, we have used an existing on-premise Oracle database as the source system and built the target system in an ASE database on Azure.

Also, we used our tenant called “OZSoft” but the process can be cloned and applied to any customer after being onboarded to IT-Conductor as a tenant. IT-Conductor creates and clones the Git repository for each tenant who needs to leverage these types of automation runbooks.

Process Definitions

We have used two process definitions for this migration scenario. To access them, navigate to the Tenant Service Grid → Process Definitions, search, and click on the following:

  1. Oracle to ASE on-prem activities

  2. TEST Migrate Oracle To ASE

Oracle to ASE On-prem Activities

In this process definition, the tasks will be performed on the on-premise system. The SMIGR_CREATE_DDL job will be run using an SSHShellJob. Then the export of the Oracle system will be performed consecutively.

After running the process definition, you can check the execution logs as shown below.

Test Migrate Oracle to ASE

The process begins with provisioning two VMs using Terraform commands. The first VM is for the ASE application and the second is for the ASE database. Once the VMs are provisioned, the migration tasks will be performed using an Ansible playbook.

The process definition contains the following activities:

  1. Provision Azure VM for ASE APP

  2. Pre-Configure ASE APP VM

  3. Install ASCS

  4. Provision Azure VM for ASE DB

  5. Pre-configure ASE DB VM

  6. Import DB

  7. Install PAS

Provision Azure VM for ASE APP Activity (VM 1)

In this activity, select the data file /configure/templates/vm_app.json.

The virtual machine to be provisioned in this activity will be used for installing the SAP application.

The .json file consists of information related to:

Infrastructure (which includes region, resource group, vnet, arm_id, subnet, and nsg)

VMs (which includes VM name, OS image ID, size, disk type, authentication, user name, Storage disk type, size (in GB), and mount points)

sshkey (which includes the path to the public key and the path to the private key)

Provision Azure VM for ASE DB Activity (VM 2)

In this activity, select the data file /configure/templates/vm_db.json.

The virtual machine to be provisioned in this activity will be used for installing the ASE (Sybase) database.

The vm_db.json contains the same information as vm_app.json, however, there will be a different hostname.

Once the changes in both files (App and DB) have been made, proceed to run the Process Definition and fill out the fields as shown below:

Note: Removal Age refers to the instance of process orchestration and is not to be mistaken for the removal of the provisioned system.

Once the process definition is running, it will start changing colors to indicate the status of each activity. After successful completion, the color of the activities will turn GREEN.

Note:

  • Virtual Machine (VM) Provisioning activities are performed via Terraform and all SAP+DB installation, import, etc. are performed via Ansible.

  • All codes are fully customizable and can be changed depending on customer requirements.

SAP on Azure Migration Dashboard

IT-Conductor dashboards allow administrators to start/stop source and target systems, and provision VMs or database nodes during migration activities.

Figure 1: Oracle to ASE On-prem Activities Process Definition
Figure 2: Oracle to ASE on-prem activities Execution Logs
Figure 3: Test Migrate Oracle to ASE Process Definition
Figure 4a: vm_app.json Data File
Figure 4b: vm_db.json Data File
Figure 5: Run Process Definition Details
Figure 6: Completed Test Migrate Oracle to ASE Process Definition
Figure 7: SAP on Azure Migration Dashboard