call us toll-free +1 855 855 3600
 
Home > Blog > Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report

Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report

Posted by | On | In Amazon Web Services, Database Migration, OLTP Databases | Tags:
 

This continues our video blog series on AWS Schema Conversion Tool. In our previous blog post Selecting target database type for migration using Assessment Report in AWS Schema Conversion Tool we talked about multi-platform Database Migration Assessment Report, which helps users to select the target database type depending on the complexity of migration and thus simplify the database migration process. And now we’ll concentrate on using the Assessment Report inside the AWS Schema Conversion Tool application.

Background

Once you have determined the target database type, the goal of the assessment report is to examine all issues that the Schema Conversion Tool identified for the database migration process. It also provides advice on how to convert different types of objects if they are not supported in the target database or could not be automatically converted by the application. This is not the weakness of AWS Schema Conversion Tool. In fact, the AWS Schema Conversion Tool can be useful at this point, because it provides some valuable comments for each database object that could not be automatically converted. This helps you to manage and overcome all errors and warnings as part of the migration effort.

There is a specific Action Items View of the Assessment Report which allows users to concentrate on items occurring during database migration process. In this format, you can easily explore the source code of database objects which caused the current issue.

In the following video we’ll show you how to use all features of Database Migration Assessment Report, including Action Items, for an already created project in the AWS Schema Conversion Tool.

 

Need help getting started? Check out our Jumpstart for SCT offer!

Observations

We used the AWS Schema Conversion Tool in several real database migration projects. We found the Assessment Report for the chosen pair of source and target database really helpful and useful in our practice. Here are some of the key findings:

  • The Assessment Report shows the exact number of issues occurring during current database migration process. It provides the detailed information on every issue, so you can estimate the time needed to solve these issues.
  • Just in one mouse click you can review the source code of functions and procedures causing the current issue. All database objects are shown in metadata trees. SCT always keeps them synchronized between each other inside the loaded migration project. So, you can easily access all the data and code objects of converted database for making the needed changes.
  • We really liked the pop-up notifications and code highlights of migration issues. These features simplify navigation inside the project.

Related posts

Stay tuned to our blog for more tips and insights into migrating databases and applications to AWS. To learn how the experts at DB Best can help you jump-start your effort, contact us to get started.

 
       
 

Leave a Reply

  • CAPTCHA Image
    Play CAPTCHA Audio
    Reload Image