SwisSQL Assessment Tool - Assess before you Migrate
Assessment is an important prerequisite before starting your
migration project. SwisSQL Assessment Tool provides detailed
information about database objects, (procedures, functions,
and triggers) their migration complexity, and how much SwisSQL
can help you with the migration. SwisSQL Assessment tool helps
you to
Understand the complexity of the database objects that
are to be migrated
Understand the level of automated migration that could
be achieved using the SwisSQL product for migrating the
database objects
Estimate the time involved in handling the migration project
Measure It : You can use the SwisSQL Assessment tool
to assess individual database files / scripts or database
objects present in a live database. The tool parses the file(s)
/ project(s) submitted for Assessment and generates detailed
reports on the database objects analyzed.
SwisSQL Assessment tool provides intuitive graphs and reports
that helps you
Understand the database object types in your project
along with the total number of lines in every object
Understand how much of automated conversion you can achieve
using SwisSQL Migration Tools
Summary table gives a view of the total number of object
types such as Functions, Triggers, and Procedures in the
assessed file(s) / project(s)
Weigh It : SwisSQL Assessment tool helps
you understand the complexity of the database objects and constructs
in your migration project. Understanding the complexity of the
database objects and constructs helps you focus and prioritize
your migration efforts.
SwisSQL Migration Assement tool provides:
Assigning Complexity: Based on the effort and
complexity involved in migrating each construct, a complexity
factor (weightage) of 1 to 5 is assigned on a scale of
least complex to most complex
Calculating Total Complexity: The given file(s)
/ project(s) are parsed and the number of occurences of
different database constructs making up a database object
(viz Procedures, Functions, Triggers) are taken into account.
Considering the summation of all the different database
object constructs count multiplied by its complexity gives
the total complexity of the database object.
Complexity of the database object = Summation
of [Construct CountXComplexity]
Construct Count = Total number of occurences
of each distinct database construct present in a database
object
Complexity = Complexity assigned to that particular
construct
Determining Convertability of database objects:
Based on SwisSQL's migration capability to automatically
convert a particular database construct to the target database
construct, the isconvertable variable in the Assessment_Complexity.xml
is set to "yes" or "no". The isconvertable
field can only take one of the two possible values - yes
and no. This value is used to identify the conversion percentage
of the tool as given below
Calculating percentage of Conversion: The Conversion
percentage is calculated, based on the total count of the
different database constructs forming the various database
objects in the given file(s)/project(s) and SwisSQL's migration
capability ( isconvertable ) for the given database construct.
Look into It : SwisSQL Assessment tool
helps you drill down and understand complete details about the
database constructs in your database migration project.
The tool helps to get a complete view about
Database object types and constructs with total number
of lines and their related complexity
Total number of occurences in the given file(s) / project(s)
Conversion Percentage for all database objects and constructs
Details about database object type such as Return Types,
Input Types, and so on
SwisSQL Assessment tool provides complete insight
about your migration project and how far SwisSQL migration tools
can help you in the same. It helps you scope, plan, and complete
your migration project efficiently without guess work.
SwisSQL Assessment tool is currently available along with
the following products:
