THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

SAP R/3

SAP R/3 database migration involves transfer of table definitions and data from about 25,000 tables to another database platform.

  • Migrating SAP R/3 from IBM DB2
    • SAP R/3 DB2 database contains about 25,000 tables and about 4,400 views in one schema SAPR3
    • Data types - CHAR, CHAR FOR BIT DATA, VARCHAR, VARCHAR FOR BIT DATA , LONG VARCHAR, LONG VARCHAR FOR BIT DATA, INTEGER, SMALLINT, BIGINT, DOUBLE, DECIMAL, TIMESTAMP, BLOB, CLOB
    • NOT NULL constraint is defined for all columns
    • Default values are defined for all columns
    • Primary keys are widely used
    • A lot of unique and non unique indexes are used - 1 to 7 indexes per table
    • A few foreign keys are used
    • No check constraints
 
Testimonials
January 15, 2019CanadaHelps, Canada

CanadaHelps, Canada


'The migration process was quick and very easy and saved us a tremendous amount...
...

July 23, 2018Novum, Germany

Novum, Germany


'Our stored procedures have been very complex with lots of dynamic SQL. No problem...
...

Case Studies
June 20, 2018Progress 4GL to .NET C# WinForms Solution, United States

Company offerings include customer relationship management (CRM), supply chain management (SCM), and human capital management (HCM) software.

Company serves over 20,000 customers in 150...

...

April 28, 2018Informix 4GL to Microsoft SQL Server Solution, United States

Our Customer is a trusted US corporation that provides human resources services and business solutions for more than 100,000 small and midsized businesses across the United States.

...

Feedback

Overall, the code looks good. It’s still easy to read and it should be fairly simple to maintain going forward. The Excel reports and other files are generating as expected.


Read more
Industry Events