| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | f1_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Assessment Report (Db2ToSQL) |
Learn how to view the results of the conversion of database objects to Transact-SQL syntax (Db2ToSQL). |
cpichuka |
cpichuka |
randolphwest |
09/24/2024 |
sql |
ssma |
conceptual |
|
|
The Assessment Report window shows the results of the conversion of database objects to [!INCLUDE tsql] syntax, and can also help you estimate the complexity and cost of your migration projects.
To access the Assessment Report, select objects to convert in source metadata explorer, right-click Schemas or Synonyms, and then select Create Report.
| Term | Definition |
|---|---|
| Conversion statistics | Shows the conversion statistics by statement type. This pane is visible when a group object, such as a schema, or an object without code is selected in the left pane. |
| Objects by Categories | Shows the number of objects by category. This pane is visible only when a group object, such as a schema, or an object without code is selected in the left pane. |
| Statistics | Shows the conversion statistics for the selected object. This pane is visible only when an individual object with code is selected in the left pane. You might have to expand Statistics, which is immediately above the Source pane, to view this pane. |
| Source | Shows the Db2 code for the selected object, and highlights code that wasn't converted to [!INCLUDE tsql]. This pane is visible only when an individual object with code is selected in the left pane. Select the line numbers to set or clear bookmarks. To navigate through the code, use the buttons at the top of the pane. |
| Target | Shows the conversion's resulting [!INCLUDE tsql] code for the selected object, and error messages for code that wasn't converted. This pane is visible only when an individual object with code is selected in the left pane. Select the line numbers to set or clear bookmarks. To navigate through the code, use the buttons at the top of the pane. |
| Messages pane | Shows the errors, warnings, and informational messages that were generated while creating the assessment report. Messages are grouped by number. To view the code that caused the error, select Errors, Warnings, or Info, expand the category of messages, and then select a message. |