AdventNet SwisSQL Home SwisSQL Sybase to SQLServer AdventNet Home
 

Migration Reports

SwisSQL Help Home SwisSQL Help Previous SwisSQL Help Next

SwisSQL Sybase to SQL Server Edition offers Summary and Detailed Reports after migration. Summary Report offers a brief overview of the migration performed. The Detailed Report is saved for users to check on the migration status of projects completed earlier. Migration reports help users to understand the outcome of a migration operation. Whenever a migration action is triggered, a migration progress viewer pops up presenting the status of the migration process to the user. At the end of the migration, the viewer provides an option to view a Summary Report of the migration operation. This option remains disabled until the migration is completed. Once enabled, users can invoke this option to view a summary information about the latest migration. Users can also click on View Detailed Report to see more specific details about the migration.

SwisSQL helps you analyze the migration with two types of reports

  • Summary Report

The summary report offers brief about the last migration performed. The summary report contains the following information as shown in the snapshot below

    SwisSQL Sybase to SQLServer Migration Reports

      • Time taken for migration : This indicates the total time taken for the migration process (for all the input objects)
      • Migration success percentage : This corresponds to the success level of migration to a scale of 100. The migration percentage is calculated as

(Total number of objects taken for migration - Total number of objects successfully migrated)


(Total number of objects taken for migration)

 

X 100

      NOTE : The objects existing in files that were not parsed by the tool will not be considered for computation of migration percentage.

      • Total number of files : Total number of files considered for migration.
      • Number of files not parsed : Total number of files that could not be parsed by the tool
      • Output directory : The migrated files are saved to the specified Output Directory
      • Reports directory : The directory in which reports pertaining to the currently concluded migration is stored
      • Conversion summary table :This table presents a count of total number of various objects taken up for migration along with the count of the number of objects which were successfully migrated by the tool. A difference in these two counts presents the total number of objects which were not converted by the tool.
    • Detailed Reports

Apart from Summary report, SwisSQL Sybase To SQL Server Edition also offers Detailed Reports for every migration. You can view the detailed report by clicking on the View Detailed Report option shown in Summary report screen. This opens up a detailed HTML report in a browser window. The detailed report consists of the following sections

Summary View section

The Summary view offers a brief overview of the migration performed with the following information

  • Migration Start time : Starting time for the migration, is the time at which the migration started
  • Migration End time : The time at which the entire migration operation was completed.
  • Total files : The total number of files taken for migration
  • Total lines : This corresponds to the total number of lines of Sybase code migrated. This is the sum of number of lines of code present in all the files taken up for migration
  • Total files not parsed : This corresponds to the total number of files that could not be parsed by the tool.
  • Output directory : This corresponds to the directory under which the migrated files are output by the tool
  • Migration percentage : This corresponds to the success level of migration to a scale of 100

SwisSQL-Sybase to SQLServer Migration Reports

Detailed Report:

You can view more details about the migration by clicking on the Detailed Report link in the header section of the report. This page presents the list of objects (categorized based on object type) that were successfully migrated. The table presents the Object Name and the status of the migration of the object.

SwisSQL Sybase to SQLServer Migration Reports

Error report section :

You can view the errors that occurred during migration by clicking on the Error Report link in the header section of the report. This page presents the list of objects (categorized based on object type) that were not migrated by the tool. Both Parse Errors as well as Conversion errors are presented in this report.

Migration Trace section :

User can understand the sequence of operations executed by the tool after the clicking on Migrate option or Migrate Selected Files option. This section can be accessed by clicking on the Migration Trace link in the header section of the report. This reports presents a table showing the sequence of events that occurred throughout the migration process.

SwisSQL Sybase to SQLServer Migration Reports

SwisSQL Help Home SwisSQL Help Previous SwisSQL Help Next

© Copyright 1996-2006 AdventNet, Inc Trademarks | Privacy Policy SwisSQL - Sybase to SQL Server