0 Replies Latest reply: Jul 25, 2007 2:47 AM by 589777 RSS

    Migration Assessment sheet query.

    589777
      Hi,

      Any hints about how the following sections (Added complexity & Factor) are derived and used in estimation for Stored Procedures, Triggers & Views. Also were the recommend values by Oracle for these sections are good enough to for the estimation or does it need any changes for more accurate estimation. I know the format got messed up, the estimation I am referring to is PTSDBMigrationAssessment.xls sheet from oracle.



      Added Complexity Description               Temp tables      Transaction Logic     Use of System tables     Global Variable (@@xxx)     raiserror without return     Dynamic generated DDL     Multiple result sets     Other Non standard features               
      Percent               20%     15%     10%     10%          5%                         
      Factor (number of levels to move)               2     2     2     1     2     2     2     2     2     1     
                     6     6     0     0     0     0     0     0     0     0     
                                                                       
      Stored Procedures               Migration Metrics                                                  
                                                                       
      Complexity Description               Simple      Medium      Medium     Complex     Complex     Very Complex     Very Complex     Extremely Complex     Extremely Complex     What were you thinking?     
      Total Number               4     5     6     5     0     0     0     0     0     0     



      Thanks
      Prakash.