Reading time: 5 min

Published December 13, 2024

The Ispirer team has recently significantly reworked and updated the Assessment Wizard reports. What exactly has been updated? Who will benefit from it? How do reports help at the assessment stage? Let’s dive in.

Assessment Wizard: what is it?


Assessment Wizard is a tool for pre-migration database assessment. The product helps with the following tasks:

  • analyze the database in a few clicks;
  • estimate its volume and number of structures;
  • estimate their complexity in the database;
  • assess the automation of the migration process using SQLWays Wizard.

Turtle icon

Based on the analyzed data, the tool estimates the time required for automatic migration and also helps estimate the cost of the migration project.

Assessment reports: What's new

Updated assessment reports contain detailed information about the database, based on which the tool provides the following insights:

  • The percentage of automation of future migration using SQLWays Wizard. Assessment Wizard assumes the potential automation level based on the analyzed code structures
  • Project complexity. The tool makes it possible to assess how complex the project is
  • Manual adjustments. Are there any necessary manual adjustments? The tool provides clear answers
  • Suggestions for customizing the tool to improve the level of automated migration. Additionally, the report will include recommendations on the number of customizations in the tool that can significantly increase the % of automatic conversion and the maximum possible % of automation obtained if you use product customizations to the maximum
Assessment automation level

For more technically savvy users, the report provides detailed information on the complexity of objects and the structures contained within them. Technical users can check why a certain level of complexity is set for a particular object and highlight those requiring more attention during the migration project. The report counts the number of objects and divides the conversion level into simple, medium, complex, and manual. Such a detailed assessment helps clients get a complete picture of the upcoming migration project.

Assessment objects complexity

In addition to a detailed assessment of database objects, the tool analyzes the database's structures. Assessment Wizard counts the number of structures and repetitions in the database and divides them into levels of complexity, from simple to complex and manual.

Assessment constructions2

Assessment Wizard allows you to drill down into general information to easily examine the details of specific SQL objects, such as stored procedures. In addition to the total count and the number of occurrences, the tool offers recommendations.

Assessment constructions1

Who can benefit from Assessment Wizard?

Assessment Wizard will be most useful in the following cases:

  • When you're unsure where to begin with a technology transition and need to estimate the resources required for the migration.
  • When migration is essential, you want to assess the effort involved while calculating potential savings from using an automated solution.
  • In case you need to pinpoint complex challenges in your existing code to plan effectively.
  • For integrators, it streamlines the evaluation of migration projects, enabling quick assessments in just a few clicks.

Ready to elevate your database migration? Start with Assessment Wizard for free!