AWS Database Migration Service Support

DB Best can help your team get up and running with AWS SCT so that you can take advantage of all the features it offers. Whether you need help understanding the assessment report, configuring migration options, using the scripting console options, or optimizing data warehouse options, we can provide your team with the customized help that you need.

AWS SCT automatically converts database objects that it understands. However, there are some database object constructs that are too complex for SCT to handle due to possible ambiguities. Since we know SCT inside and out, we know exactly what the issues are and can help manually convert the code to your desired AWS RDS target database. In addition, we can help you understand the estimates from the assessment report to help scope your migration project with greater accuracy. In some cases a migration project requires additional automation to improve conversion rate on top of SCT. The DB Best development team is happy to help build additional automation layers to expedite your migration projects.

The AWS Database Migration Service is a web service which you can use to migrate data from a source database to a target database. We can help you set up custom mapping rules between DMS and SCT. For very large data volumes, you may need to use the AWS Snowball service to ship your data to an AWS data center and then load it into your target AWS RDS or Amazon Redshift database. Our experts can help develop strategies and customized data movement scripts using popular data integration tools to ensure data integrity throughout the project. We also have tools like Database Compare Suite that are available for purchase to compare schema and data after conversion.

AWS SCT can identify and convert application code for Java, C++, C# or “any” source projects using the AWS SCT Application Conversion Project. It’s certainly a great start, however, it’s not perfect. DB Best has a variety of tools that we have developed over the years to help identify application code and fix the code to work against the new AWS RDS database. In addition, if you are looking to change the application front end from Oracle Forms to Web Applications, we have tools and processes to guide you through the rewrite effort.

After AWS SCT finishes converting the code, you need to test its correctness. Functional testing represents approximately 30% of the migration effort. We have our homegrown tools and frameworks which can help to expedite the functional testing process.

AWS SCT uses a migration extension library for the source database to emulate the same feature using the target AWS RDS database. In many cases, our experts can improve performance by looking at the intent of the source object and then using the native functionality of target AWS RDS to achieve that same functionality. For data warehouse migration, our experts can show you how to use SCT’s optimization tools to get the best performance out of Amazon Redshift.

Database schema conversion typically represents approximately 15% of the effort in a migration project. AWS DMS and SCT will not do it all. Our experts can work with your team to evaluate your current database, applications, and infrastructure to help you develop the future state architecture. From there, we can work with your team to develop a project plan using our 12-step migration methodology to place you on a path to success.

In some cases, database features can’t be converted to equivalent Amazon Relational Database Service (Amazon RDS) features. Some examples are Oracle send email calls that use UTL_SMTP, and Microsoft SQL Server jobs that use a job scheduler. If you host and self-manage a database on the Amazon Elastic Compute Cloud (Amazon EC2) platform, you can emulate these features by substituting AWS services for them. Our experts can help you configure AWS Services for sending emails and performing automated jobs using AWS Lambda functions. We can also help you to extend existing libraries to provide a greater support for missing source database features using existing foundation provided by AWS SCT Extension libraries.