User Guide › Introduction

Introduction

Data migration processes tend to be complex and tedious, keeping DBA teams busy for months and involving risks and lengthy downtime. Despite thorough planning, many projects fail to meet their schedule and budget or yield bad data quality in the target application.
Driven by the vision that automation and methodology are the key to faster processes and better results, Accelario set up a team to develop a migration tool that incorporated his abundant field experience. Initial trials clearly proved the case for Accelario as a top solution, which quickly came to be deployed for diverse use cases in consulting projects.

Over the past years, hundreds of databases have been migrated and consolidated with the help of Accelario Migration Suite. Constantly refined and complemented with new features and technologies, the Suite tackles virtually any Oracle cross-platform migration scenario and refresh needs of our customers.

Accelario Migration Suite is an innovative and proven software solution for logical cross-platform migration of Oracle databases. Built on our 5-step migration methodology, the Accelario Suite automates and accelerates migration and consolidation processes and greatly mitigates risks. Organizations benefit from optimized data quality on the target platform and immediate ROI through greatly reduced project duration, costs and cutover times compared to those incurred by manually implemented projects.

 

KEY CAPABILITIES AND USE CASES

Proven solution for logical cross-platform migration, from any to any platform
OS-agnostic: supports UNIX, Linux, Windows and migrations from one operating system to another.
Designed for efficient migration to Exadata: supports unique features such as HCC compression, live migration, smart flash cache, etc. to ensure optimized Exadata performance.
Built for complex migration projects involving parallel work, excessive data amounts and consolidation of various sources into one target database.
Supports latest Oracle versions and technologies (12c, Container technology, etc.)
Specific migration approach and rules for each individual platform, database version or application type (e.g. data warehouse, online production environments) according to industry best practices.

Accelario Migration Suite V2.3 released in January 2015. Some of the new features are:

  • Data Masking engine for Data Laundry purpose – copy data from production to test while masking the production data
  • Copy control module – Ability to select and copy partial set of data, a single table or specific range.
  • GUI-based management interface
  • Support readiness for additional data objects
  • Comprehensive reports

 

ENVIRONMENT REFRESH MANAGEMENT AT A FINGERTIP

Copying and refreshing data between production, test and development environments is daily business for many DBAs. Choosing the right copying method, configuring source and target database, accurately forecasting storage and testing duplicated data tend to be lengthy complex processes, and even more so when different platforms or RDBMS versions are involved. Organizations today need to MASK their data while it is moving from Production to Test.

Accelario Environment Refresh Manger (ERM) presents a new and highly efficient approach to data duplication and refresh processes across environments.
This automated tool provides DBAs with unprecedented management abilities and full control both at source and target, while accelerating execution and reducing source down time. Data moving rendered efficient and transparent with ERM, which automatically compresses data in the target environment and optimizes performance.

 

5-STEP MIGRATION

Accelario solutions are based on the 5-step migration methodology we developed to automate and streamline data migration processes. Our methodology enables to move, refresh, consolidate and clone databases in one phase, providing full control over the process and making script writing obsolete.
Accelario intuitive Management Interface walks users step by step through the process:

  1. Prepare prior to copy
    Preparing database infrastructure on the target (users, Tablespaces, compression types and more)
  2. Copy data
    Moving data with full control for users on both source and target sides.
    Data from multiple sources (clone, physical server, production, test environments) copied in parallel; pace set mainly by source power and size of tables.
    As an advanced option, data moving combined with compression.
  3. Create indexes
    Simultaneous to copy process and performance monitoring: online configuration and property adaptation for maximum results
  4. Copy views, procedures and sequences
    Building views, procedures, sequences, etc. for all objects on the target
  5. Compare and test
    Compare source and target. End user or application owner can start testing process. Run first back up on target. Ready to build DR.

 


This User Guide will allow you to go step by step configuring Accelario for your needs, and enjoy this solution immediately. Start with Accelario Definitions section to have a better understanding on a few wordings. Please contact us directly for any questions info@accelario.com.