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
SummaryStatus
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
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
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.
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
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.