MySQL如何制作报表_(MySQLToSQL) 生成报表 - SQL Server

本文链接：https://blog.csdn.net/weixin_30910583/article/details/113109662

生成报告 (MySQLToSQL)Generating Reports (MySQLToSQL)

01/19/2017

本文内容

使用命令执行的某些活动的报告在对象树级别的 SSMA 控制台中生成。The reports of certain activities performed using commands are generated in SSMA Console at object tree level.

使用以下过程来生成报表：Use the following procedure to generate reports:

指定写入摘要-报表-报表-到参数。Specify the write-summary-report-to parameter. 如果在指定的) 或文件夹中指定，相关报表将存储为文件名 (。The related report is stored as the file name (if specified) or in the folder you specify. 文件名按下表中所述进行系统预定义，其中， ** < n > **是在每次执行同一命令时以数字递增的唯一文件号。The file name is system-predefined as mentioned in the table below where, is the unique file number that increments with a digit with each execution of the same command.

报告 vis-vis 命令包括：The reports vis-à-vis commands are:

Sl.Sl. 错误。No.

命令Command

报表标题Report Title

生成-评估-报表generate-assessment-report

AssessmentReport < n > 。XMLAssessmentReport.XML

转换-架构convert-schema

SchemaConversionReport < n > 。XMLSchemaConversionReport.XML

迁移-数据migrate-data

DataMigrationReport < n > 。XMLDataMigrationReport.XML

convert-sql 语句convert-sql-statement

ConvertSQLReport < n > 。XMLConvertSQLReport.XML

同步-目标synchronize-target

TargetSynchronizationReport < n > 。XMLTargetSynchronizationReport.XML

从数据库刷新refresh-from-database

SourceDBRefreshReport < n > 。XMLSourceDBRefreshReport.XML

重要

输出报告不同于评估报告。An output report is different from Assessment Report. 前者是有关执行的命令的性能报告，后者是用于编程的 XML 报告。The former is a report on the performance of an executed command while, the latter is an XML report for programmatic consumption.

对于输出报表的命令选项 (Sl。For the command options for output reports (from Sl. 错误。No.

使用报表详细级别设置指示输出报表中所需的详细信息的范围：Indicate the extent of detail you desire in the output report using the Report Verbosity settings:

Sl.Sl. 错误。No.

命令和参数Command and Parameter

输出描述Output Description

verbose = "false"verbose="false"

生成活动的汇总报表。Generates a summarized report of the activity.

verbose = "true"verbose="true"

为每个活动生成汇总且详细的状态报告。Generates a summarized and detailed status report for each activity.

备注

上面指定的报表详细级别设置适用于 "生成-评估-报表"、"转换架构"、"迁移数据"、"转换-sql 语句" 命令。The Report Verbosity Settings specified above are applicable for generate-assessment-report, convert-schema, migrate-data, convert-sql-statement commands.

使用错误报告设置来指示错误报告中所需的详细信息的范围：Indicate the extent of detail you desire in the error reports using the Error Reporting settings:

Sl.Sl. 错误。No.

命令和参数Command and Parameter

输出描述Output Description

报告错误 = "false"report-errors="false"

没有关于错误/警告/信息消息的详细信息。No details on error/ warning/ info messages.

报告错误 = "true"report-errors="true"

详细的错误/警告/信息消息。Detailed error/ warning/ info messages.

备注

上面指定的错误报告设置适用于 "生成-评估-报表"、"转换架构"、"迁移数据"、"转换-sql 语句" 命令。The Error Reporting Settings specified above are applicable for generate-assessment-report, convert-schema, migrate-data, convert-sql-statement commands.

object-name=""

object-type=""

verbose=""

report-erors=""

write-summary-report-to=""

assessment-report-folder=""

assessment-report-overwrite=""

同步-目标：synchronize-target:

命令同步-目标具有 " 报告错误- 目标" 参数，该参数指定同步操作的错误报告的位置。The command synchronize-target has report-errors-to parameter, which specifies the location of error report for the synchronization operation. 然后，按名称TargetSynchronizationReport < n > 。XML是在指定的位置创建的，其中** < n > **是在每次执行同一命令时以数字递增的唯一文件号。Then, a file by name TargetSynchronizationReport.XML is created at the specified location, where is the unique file number that increments with a digit with each execution of the same command.

注意：如果提供了文件夹路径，则 "报告错误到" 参数将成为命令 "同步目标" 的可选属性。Note: If the folder path is given, then 'report-errors-to' parameter becomes an optional attribute for the command 'synchronize-target'.

object-name=""

on-error=""

report-errors-to=""

对象名称：指定 () 用于同步的对象 (它还可以具有单个对象名称或) 的组对象名称。object-name: Specifies the object(s) considered for synchronization (It can also have indivdual object names or a group object name).

错误：指定是否将同步错误指定为警告或错误。on-error: Specifies whether to specify synchronization errors as warnings or error. 针对出错的可用选项：Available options for on-error:

报表-总警告report-total-as-warning

报告-每个警告report-each-as-warning

fail-脚本fail-script

从数据库刷新：refresh-from-database:

从数据库刷新的命令具有报表错误-目标参数，该参数指定刷新操作的错误报告的位置。The command refresh-from-database has report-errors-to parameter, which specifies the location of error report for the refresh operation. 然后，按名称SourceDBRefreshReport < n > 。XML是在指定的位置创建的，其中** < n > **是在每次执行同一命令时以数字递增的唯一文件号。Then, a file by name SourceDBRefreshReport.XML is created at the specified location, where is the unique file number that increments with a digit with each execution of the same command.

object-name=""

object-type =""

on-error=""

report-errors-to=""

对象名称：指定 () 用于刷新的对象 (它还可以具有单个对象名称或) 的组对象名称。object-name: Specifies the object(s) considered for refresh (It can also have indivdual object names or a group object name).

错误：指定是否将刷新错误指定为警告或错误。on-error: Specifies whether to specify refresh errors as warnings or error. 针对出错的可用选项：Available options for on-error:

报表-总警告report-total-as-warning

报告-每个警告report-each-as-warning

fail-脚本fail-script

另请参阅See Also