Data Migration tools from Any DB to HANA or Any DB

Blog, Data, HANA

Data Migration tools from Any DB to HANA or Any DB

webadmin
July 2, 2017
LinkedIn0Shares0

Below SAP tools can be considered for data migration from any DB to HANA or Any DB.

DMO option is generally recommended when complete system migration is happening however there are Pros and Cons of all these tools and methods to do the data migration mentioned below which will help you to take the decision.

Rapid Data Migration from SAP DS (Data Services)

Pros:

  1. Pre built best practices content over 40 critical master and transactional data objects like material master, profit center group, business partner and  sales orders, purchase orders, contracts and more
  2. This tool allows to extract and analyze selected data from virtually any source system
  3. No License cost, as ETL (Extract, Transfer, and Load) functionality is free of cost provided with SAP Data Services software
  4. By cleansing, validating, transforming, and migrating data from any system to SAP S/4HANA, we can have high quality legacy data in SAP solution in only a few weeks with the use of rapid data migration

Cons:

  1. Duration of the project will be more as first new SAP BODS instance will be setup and then project creation in DS and rest of the activities will take place.
  2. New Database need to be setup for DS repository

 

DMO (Database Migration Option of SUM)

 

Pros:

  1. DMO is SAP tool which is a part of SAP SUM (Software Update Manager), no other license is required.
  2. Duration with this method will be time required for system migration only.
  3. No Separate instance or database is required

 

Cons:

  1. Data Migration will happen along with new S/4 HANA or regular SAP instance installation.

 

TDMS (Test Data Migration Server)

 

These days TDMS is also getting used to migrate the data between HANA or any DB to HANA database. It’s usage in converting the ECC data in business suite S/4 data is not known or explored.

Pros:

  1. No new instance is required, ECC with DMIS component can be used as central TDM system itself
  2. This tool can be used for System copies as well along with data slice and scramble capability

 

Cons:

  1. Time required for system copy or selected data migration using TDMS is quite huge

 

LinkedIn0Shares0