Wednesday, 9 February 2011

Migration Reports 3.0

We have revamped the migration reports in SQL Developer 3.0 to provide significantly more information about your migration. Instead of "hiding" this information under the Migration Report navigator , now the reports can be viewed by double clicking on any of the folder nodes in the Migration navigator. The reports are smart enough to tailor the information depending on where in the Migration Navigator you click.


Status

Gives you a heads up of the status of each migration project/model.
Also provides links which when double clicked, launch the migration wizard to perform the appropriate action


Summary

Provides the number of objects (tables, procedures, views , ... ) involved in each of the migration projects.It then breaks down into the number of objects in each database or owner.


Analysis

Provides fine grain details about the databases and objects being migrated.
SQL Size Chart
Visualize size of all SQL Objects
SQL Size Summary
Number of SQL Objects with similar sizes
SQL Size Details
Line size for every SQL Object
Columns
Details of all captured colums
Name Changes
All the name changes between the captured objects and the converted objects
Dependencies
Dependency tree between store procedures and other objects

Temporary Table Summary
Summary of the number of temporary tables per project / database
Temporary Table Details
List of all temporary tables identified and their parent procedure
Parameters
List of all procedure and function parameters including new params


Capture Issues

There should be no capture issues, but if an issues occurs it will be listed here


Conversion Status

Lists the number of Procedures, Triggers and Views which converted or failed to convert

Conversion Issues

Reports on all the issues which where encountered during the conversion.
Errors denote objects which failed to convert.
Limitations denote objects which converted but a particular statement or clause was not supported


Target Status

After selecting an appropriate connection to the target database and clicking refresh, this report will list all the objects in the converted model and their status in the target database. Valid, Invalid or Missing


Target Issues

After choosing the appropriate Target connection and clicking refresh, this looks at the issues of each object in the target database.


Data Quality

After selecting the appropriate
Model, Source Connection and Target Connection click Analysis.

You will be prompted to continue as you are reminded that a full table scan of all the tables on the source connection and target connection will take place.


SELECT count(*) from tablename is performed against each table and the values inserted into the migration repository.

Once complete, click refresh. Each table migrated is listed with the source row number and the target row number, making it easy to identify tables where all the data was not migrated

Note that SELECT count(*) from tablename may make a significant impact on the performance of the source and target database so best run only on non production databases.


Model Comparison

After choosing the first captured model and the second captured model click refresh. The differences between the models will be listed.

This is useful when trying to identify changes to your source database over a period of time , sometimes called the delta.

This knowledge can help identify any new or modified objects which require migration.