Managing SwisSQL Projects

AdventNet SwisSQL Sybase to SQL Server Edition helps you save your complete migration environment with source files, migrated files, logs, and reports as SwisSQL projects. With the migration environment saved in projects, you can fine tune and refine the output with repeated migration. SwisSQL projects are stored under

<SwisSQL Home \ projects > Eg: C: \AdventNet\SwisSQL\SybaseToSQLServer2.1\Projects directory. The project organization is applicable only for Online migration.

Project Structure : SwisSQL projects store all source Sybase T-SQL files, all target SQL Server objects, along with the logs and reports. The snapshot given below shows the contents of the SwisSQL projects

SwisSQL stores complete migration environment under <SwisSQL Home \ projects > project_name folder with the source files being placed under the TSQL folder. The migrated files are placed under ConvertedMSSQL folder. The table shows the project organization.

Both TSQL and ConvertedMSSQL folders have database objects, that are grouped depending on their type such as Index, Tables, Triggers etc.

• TSQL

  This folder contains Sybase ASE database objects such as Indexes, MetaData, Procedures, Tables, Triggers, Views, and ProcessFlow. Information stored in ProcessFlow and MetaData folders are internally used by the tool.
  
  

• ConvertedMSSQL

  This folder contains equivalent converted SQL Server objects such as Indexes, Procedures, Tables, Triggers, View to the corresponding sources files

• Tracking Every Migration: Every time you load a project and migrate, a folder with the name swissql_migration_n will be created under Project_Name directory, where n represents the number of times the project has been migrated. The swissql_migration_n will have Logs and Reports related to every migration. Logs will hold the details about input objects, summary of migration, errors, and trace. Detailed Migration reports are saved with every migration for users to analyze the migration.

• swissql_migration_1
  • Logs
  • Reports

    Logs folder contains four XML files, EntityLog, ErrorLog, SummaryLog, Trace. Which are used as part of Detailed Migration report generation

  The EntityLog contains information about the various database entities such as Tables, Triggers, number of lines of code in each entity and status of migration. The ErrorLog contains information about the errors, exceptions during migration. Trace offers complete details about sequence of conversion with time stamp. Summary offers a brief about the migration performed.

  Reports generated after every migration are stored in the Reports folder. The Reports folder contains four html files, Detailed Report, Error Report, Migration Trace and Summary. You can view index.html in the Reports folder to navigate through the report.