Generate an assessment report for a fleet of database servers using the Amazon SCT multiserver assessor

海外精选
海外精选的内容汇集了全球优质的亚马逊云科技相关技术内容。同时,内容中提到的“AWS” 是 “Amazon Web Services” 的缩写,在此网站不作为商标展示。
0
0
{"value":"[AWS Schema Conversion Tool](https://aws.amazon.com/dms/schema-conversion-tool/) (AWS SCT) is a service that allows you to migrate heterogeneous databases by converting your existing database schema from one supported database engine to another. This tool has a functionality called assessment reporting. Based on the source and target database engines you choose and the object attributes in your source schema, the assessment tool generates reports on complexity level and efforts needed on your migration tasks and action items. You can use the effort estimates and plan the migration accordingly.\n\nWith release 647, AWS SCT introduced a new feature called the [multiserver assessment report](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_AssessmentReport.html). Instead of one source and one target in one project, you can add multiple sources, and for each source, you can specify one or more potential target engines. The process is now simplified—you no longer need to create a project before you run the assessment report. The interface accepts three inputs: the project name, a location (where you want to save your assessment report), and the connections file (a CSV file containing multiple source schemas, their database server connection information, and the target database engines). The AWS SCT multiserver assessor evaluates the fleet of database servers to produce an aggregated report on top of the regular engine-specific reports, and shows the estimated complexity for each migration pair.\n\nIn this post, we show you how to configure the [AWS SCT multiserver](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_AssessmentReport.Multiserver.html) assessor to generate an aggregated report.\n\n#### **Solution overview**\n\nThe solution is best suited for the following use cases:\n\n- You need to perform a fleet-wide database assessment\n- You need to profile the schema, objects, and attributes in the source database to identify the complexity and level of effort of a migration\n- You need to run an aggregated assessment report for all possible heterogenous database migration targets in AWS\n- You need to compare migration complexity for multiple target databases in AWS\n\nFleet-wide database migration assessment can be complicated. It involves running multiple assessment reports. Without the AWS SCT multiserver feature, adding additional migration pairs is challenging and requires tremendous effort.\n\nWith AWS SCT multiserver assessment, you use a single file as input. This reduces the cumbersome process of manually running on each server and enables automation through programmatic access. You don’t need to pre-create the target database engines—they’re actually virtual. You don’t even need to have AWS Cloud access; you can run AWS SCT from your on-premises machines. Enterprise customers with a large number and variety of source database engines can now process assessments more efficiently. You can quickly develop a migration strategy by comparing the target engines based on effort levels provided by AWS SCT multiserver assessment reports and build the roadmap of your database migration to AWS.\n\nThis post uses a Windows server to run AWS SCT. To demo the most common database conversion scenarios, we consider the source and target engines in the following table:\n\n![image.png](https://dev-media.amazoncloud.cn/a6b86909861f4de8930bb8056112034e_image.png)\n\nThe solution includes the following high-level steps:\n\n1. Download and install AWS SCT\n2. Download the JDBC drivers for the source databases\n3. Configure JDBC drivers in AWS SCT global settings\n4. Configure memory settings for AWS SCT performance\n5. Create an input CSV file\n6. Run the multiserver assessment report\n7. Locate and view the assessment reports\n\n#### **Prerequisite**\n\nBefore you run the multiserver assessment report, make sure you complete the following prerequisites:\n\n- Make sure the server where you run AWS SCT has access/connectivity to your source databases.\n- In each of your source databases, you should create an AWS SCT user and grant the user the required privileges. For details on granting permissions, refer to the following resources:\n- [Privileges for Oracle as a source](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Permissions)\n- [Privileges for Microsoft SQL Server as a source](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Permissions)\n- [Using IBM Db2 LUW as a source for AWS SCT](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.DB2LUW.html)\n- [Using SAP ASE (Sybase ASE) as a source for AWS SCT](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SAP.html)\n\n#### **Download and install AWS SCT**\n\nFor instructions on getting started with AWS SCT, refer to [Installing, verifying, and updating AWS SCT](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html). The process consists of three steps:\n\n1. Download the latest AWS SCT software for Microsoft Windows\n2. Extract the installer file\n3. Install it by opening the .msi file\n\n#### **Download JDBC drivers for the source databases**\n\n Download the required drivers for each of the source databases:\n\n- **Oracle driver** – [ojdbc8.jar](https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html)\n- **SQL Server driver** – [mssql-jdbc-7.2.2.jre11.jar](https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#72)\n- **IBM DB2 LUW driver** – [db2jcc-db2jcc4.jar](https://www.ibm.com/support/pages/node/382667)\n- **SAP ASE driver** – [jconn4.jar](https://www.sap.com/developer/trials-downloads/additional-downloads/sdk-for-sap-adaptive-server-enterprise-16-13351.html)\n\n#### **Configure JDBC drivers in AWS SCT global settings**\n\nTo configure your JDBC drivers, complete the following steps:\n\n1. Launch your AWS SCT client\n2. On the **Settings** menu, choose **Global settings**\n3. Choose **Drivers**\n4. Choose **Browse** and choose the JAR file for each source database engine\n5. Choose **OK**\n\n\nFor more details or to download and install other database drivers, refer to [Installing the required database drivers](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html#CHAP_Installing.JDBCDrivers).\n\n#### **Configure memory settings for AWS SCT performance**\n\nThe AWS SCT assessment report can consume a large amount of memory, especially when you have many objects in a schema. The default allocated memory to AWS SCT is less than 1 GB. To avoid an ```OutOfMemoryError```, you should allocate more memory to AWS SCT before you run the report.\n\n1. On the **Settings** menu, choose **Global settings**\n2. Choose **Performance and memory**\n3. Select **Balance speed and memory consumption (experimental mode)**\n4. Choose **JVM options**\n5. Choose **Edit config file**\n6. Choose **OK** on the confirmation page\n7. Edit the file by adding two lines to the JavaOptions section. For example, if you have 16 GB memory available to your server, you can set the minimum JVM to 1 GB and maximum JVM to 12 GB.\n ```Xmx12288M```\n ```Xms1024M```\n8. Save the file and restart AWS SCT\n\n#### **Create an input CSV file**\n\nAWS SCT accepts a connections file as input. In the file, you describe your source schema, server connection information, and target engines.\n\nThe following is an example connections file in Excel. It shows the column values and syntax for Oracle, SQL Server, DB2, and Sybase as sources. The conversion targets are [Amazon Aurora MySQL-Compatible Edition](https://aws.amazon.com/rds/aurora/mysql-features/), [Amazon Aurora PostgreSQL-Compatible Edition](https://aws.amazon.com/rds/aurora/postgresql-features/), [Amazon Redshift](http://aws.amazon.com/redshift), and [Amazon Relational Database Service (Amazon RDS) for MariaDB](https://aws.amazon.com/rds/mariadb/).\n\n\n![image.png](https://dev-media.amazoncloud.cn/433123fd9eaf47a7804647d3233e88b7_image.png)\n\nSubstitute the parameters with true values and save it as CSV file on your local computer.\n\nThe following is an example created for this demo:\n\n```\\nName,Description,Secret Manager Key,Server IP,Port,Service Name,SID,Source Engine,Schema Names,Use Windows Authentication,Login,Password,Use SSL,Trust store,Key store,SSL authentication,Target Engines \\nOracle-app-1,,,<hostip>,1521,ORCL,,ORACLE,DMS_SAMPLE,,sctuser,<loginuserpassword>,,,,,AURORA_MYSQL;AURORA_POSTGRESQL;REDSHIFT\\nMSSQL-app-1,,,<hostip>,1433,,target_audience,MSSQL,dms_sample.dbo,,sctuser,<loginuserpassword>,,,,,AURORA_MYSQL;AURORA_POSTGRESQL;MARIA_DB\\nDB2-app-1,,,<hostip>,50000,,SAMPLE,DB2LUW,DB2INST1,,sctuser,<loginuserpassword>,,,,,AURORA_MYSQL;AURORA_POSTGRESQL\\nSYBASE-app-1,,,<hostip>,5001,,P1723126234,SYBASE_ASE,mydb.dbo,,sctuser,<loginuserpassword>,,,,,AURORA_MYSQL;AURORA_POSTGRESQL\\n```\n\n#### **Run the multiserver assessment report**\n\nTo run the multiserver assessment report, complete the following steps:\n\n\n1. Launch AWS SCT\n2. On the **File** menu, choose **New multiserver assessment**\n3. For **Project name**, enter a name for your assessment project (for this post, Multiserver assessment1)\n4. For **Location**, enter the directory where you want the reports to be generated\n5. For **Connections file**, enter the full path for the CSV file you created\n6. Choose **Run**\nFigure 1 shows example entries for step 1 through step 6.\n\n\n![image.png](https://dev-media.amazoncloud.cn/32a1999cfc494d8cb5ca20b6598d2ed3_image.png)\nFigure – AWS SCT Multiserver assessment interface 1\n7. Choose Yes to proceed on the confirmation page as in Figure 2.\n\n![image.png](https://dev-media.amazoncloud.cn/07414e8c6afa42fc84a762bba9cea79a_image.png)\n\nFigure 2 – AWS SCT Multiserver assessment interface 2\n\n\nAfter the report runs successfully, a pop-up message appears with a button Open Report as shown by Figure 3.\n\n![image.png](https://dev-media.amazoncloud.cn/1d80315bc36e48aa861417782a75e681_image.png)\nFigure 3 – AWS SCT Multiserver assessment report run completed page\n\n#### **Locate and view the assessment reports**\n\nAWS SCT builds a directory tree and saves the reports in each directory according to the parameters you entered earlier. In the following example, as shown by Figure 4, the AWS SCT reports are generated under \t```c:\\\\Users\\\\Administrator\\\\AWS Schema Conversion Tool\\\\Projects\\\\Multiserver assessment1.```\n\n![image.png](https://dev-media.amazoncloud.cn/2b28ba91ddd04fdc8c6f43a142d05acf_image.png)\nFigure 4 – AWS SCT Multiserver assessment report directory structure\n\n#### **Aggregated report**\n\nThe aggregated report presents conversion complexity by each source schema and its targets. Conversion complexity is the level of difficulty to perform the migration to the target engine. 1 represents the lowest level of complexity, and 10 represents the highest level of complexity.\n\nFor example, Figure 5 is part of the aggregated report. It shows the conversion complexity for each source schema targeting at Aurora MySQL and Aurora PostgreSQL. Based on this report, you may choose MySQL or PostgreSQL as the target engine for your Sybase and DB2 schemas because the complexity levels are low (equal to 1). However, for Oracle and SQL Server schemas, Aurora PostgreSQL may be a better choice because Aurora MySQL costs three times the effort compared to Aurora PostgreSQL.\n\n![image.png](https://dev-media.amazoncloud.cn/c416e881c8f1445e82af5db557be6337_image.png)\nFigure 5 – AWS SCT Multiserver assessment aggregated report\n\n#### **Specific engine assessment reports**\n\nIn additional to the aggregated report, AWS SCT generates four reports for each specific source and target pair. For example, Figure 6 displays the files created for Oracle to Aurora PostgreSQL conversion.\n\n![image.png](https://dev-media.amazoncloud.cn/1f1fc35ed1984b00bd1396e5660081d5_image.png)\nFigure 6 – AWS SCT Multiserver assessment reports for a specific source and target engine pair\n\nAWS SCT assigns an **Action item** number to the conversion issues that can’t be resolved by AWS SCT automatically in the detailed CSV report. It then summarizes the number of occurrences and assigns a score for **Learning curve efforts** (effort needed to design an approach) and **Efforts to convert an occurrence of the action item** (effort needed to convert each action item, per the designed approach) in the summary report. See Figure 7.\n\n![image.png](https://dev-media.amazoncloud.cn/9010a3e4c32e4735b768eaee05a1d71b_image.png)\nFigure 7 – AWS SCT Action Items summary report for a specific source and target engine pair\n\nIn Figure 7, action item 5025 in the packaged procedure \t\t\t```SELLRANDOMTICKETS``` has unsupported syntax. AWS SCT assigned 8 to the learning curve effort and 160 to the conversion effort for each occurrence. Compared to other items, it’s considered an expensive item because the scores for both columns are higher. You should plan accordingly to allocate more time to this item.\n\n#### **Summary**\n\nIn this post, we showed you how to configure and run an AWS SCT multiserver assessment report. We also demonstrated where to locate and view the reports. The multiserver feature allows you to mix and match your source and target engines so that you can get the most benefit from one process. AWS SCT aggregates and analyzes the action items, assesses the conversion effort for the entire schema as well as specific items, and presents these in a group of reports.\n\nYou can use these estimates to efficiently plan ahead for your database migrations. We appreciate your feedback!\n\n#### **About the Authors**\n\n![image.png](https://dev-media.amazoncloud.cn/c6223f61aa2a49eab47e26d9e009646a_image.png)\n\n**Shunan Xiang** is a Senior Database Consultant with the Professional Services team at AWS. He works as a database migration specialist to help Amazon customers in design and implementing scalable, secure, performant, and robust database solutions on the cloud.\n\n![image.png](https://dev-media.amazoncloud.cn/6289eede9563474390c6c90c23970bdd_image.png)\n\n**Li Liu** is a Senior Database Specialty Architect with the Professional Services team at Amazon Web Services. She helps customers to migrate traditional on-premise databases to AWS cloud. She specializes in database design, architecture and performance tuning.\n\n![image.png](https://dev-media.amazoncloud.cn/fe243a77f4bf4b61a6a3ceb6e5d4240c_image.png)\n\n**Vaibhav Khandelwal** is a Senior Product Manager with the [AWS Database Migration Service](https://aws.amazon.com/cn/dms/?trk=cndc-detail)s (AWS DMS) and AWS Schema Conversion Tool (AWS SCT) team. He leads the roadmap for AWS SCT and helps customers migrate and modernize their legacy database and analytics systems on AWS.\n\n","render":"<p><a href=\\"https://aws.amazon.com/dms/schema-conversion-tool/\\" target=\\"_blank\\">AWS Schema Conversion Tool</a> (AWS SCT) is a service that allows you to migrate heterogeneous databases by converting your existing database schema from one supported database engine to another. This tool has a functionality called assessment reporting. Based on the source and target database engines you choose and the object attributes in your source schema, the assessment tool generates reports on complexity level and efforts needed on your migration tasks and action items. You can use the effort estimates and plan the migration accordingly.</p>\\n<p>With release 647, AWS SCT introduced a new feature called the <a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_AssessmentReport.html\\" target=\\"_blank\\">multiserver assessment report</a>. Instead of one source and one target in one project, you can add multiple sources, and for each source, you can specify one or more potential target engines. The process is now simplified—you no longer need to create a project before you run the assessment report. The interface accepts three inputs: the project name, a location (where you want to save your assessment report), and the connections file (a CSV file containing multiple source schemas, their database server connection information, and the target database engines). The AWS SCT multiserver assessor evaluates the fleet of database servers to produce an aggregated report on top of the regular engine-specific reports, and shows the estimated complexity for each migration pair.</p>\\n<p>In this post, we show you how to configure the <a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_AssessmentReport.Multiserver.html\\" target=\\"_blank\\">AWS SCT multiserver</a> assessor to generate an aggregated report.</p>\\n<h4><a id=\\"Solution_overview_6\\"></a><strong>Solution overview</strong></h4>\\n<p>The solution is best suited for the following use cases:</p>\n<ul>\\n<li>You need to perform a fleet-wide database assessment</li>\n<li>You need to profile the schema, objects, and attributes in the source database to identify the complexity and level of effort of a migration</li>\n<li>You need to run an aggregated assessment report for all possible heterogenous database migration targets in AWS</li>\n<li>You need to compare migration complexity for multiple target databases in AWS</li>\n</ul>\\n<p>Fleet-wide database migration assessment can be complicated. It involves running multiple assessment reports. Without the AWS SCT multiserver feature, adding additional migration pairs is challenging and requires tremendous effort.</p>\n<p>With AWS SCT multiserver assessment, you use a single file as input. This reduces the cumbersome process of manually running on each server and enables automation through programmatic access. You don’t need to pre-create the target database engines—they’re actually virtual. You don’t even need to have AWS Cloud access; you can run AWS SCT from your on-premises machines. Enterprise customers with a large number and variety of source database engines can now process assessments more efficiently. You can quickly develop a migration strategy by comparing the target engines based on effort levels provided by AWS SCT multiserver assessment reports and build the roadmap of your database migration to AWS.</p>\n<p>This post uses a Windows server to run AWS SCT. To demo the most common database conversion scenarios, we consider the source and target engines in the following table:</p>\n<p><img src=\\"https://dev-media.amazoncloud.cn/a6b86909861f4de8930bb8056112034e_image.png\\" alt=\\"image.png\\" /></p>\n<p>The solution includes the following high-level steps:</p>\n<ol>\\n<li>Download and install AWS SCT</li>\n<li>Download the JDBC drivers for the source databases</li>\n<li>Configure JDBC drivers in AWS SCT global settings</li>\n<li>Configure memory settings for AWS SCT performance</li>\n<li>Create an input CSV file</li>\n<li>Run the multiserver assessment report</li>\n<li>Locate and view the assessment reports</li>\n</ol>\\n<h4><a id=\\"Prerequisite_33\\"></a><strong>Prerequisite</strong></h4>\\n<p>Before you run the multiserver assessment report, make sure you complete the following prerequisites:</p>\n<ul>\\n<li>Make sure the server where you run AWS SCT has access/connectivity to your source databases.</li>\n<li>In each of your source databases, you should create an AWS SCT user and grant the user the required privileges. For details on granting permissions, refer to the following resources:</li>\n<li><a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Permissions\\" target=\\"_blank\\">Privileges for Oracle as a source</a></li>\\n<li><a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Permissions\\" target=\\"_blank\\">Privileges for Microsoft SQL Server as a source</a></li>\\n<li><a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.DB2LUW.html\\" target=\\"_blank\\">Using IBM Db2 LUW as a source for AWS SCT</a></li>\\n<li><a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SAP.html\\" target=\\"_blank\\">Using SAP ASE (Sybase ASE) as a source for AWS SCT</a></li>\\n</ul>\n<h4><a id=\\"Download_and_install_AWS_SCT_44\\"></a><strong>Download and install AWS SCT</strong></h4>\\n<p>For instructions on getting started with AWS SCT, refer to <a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html\\" target=\\"_blank\\">Installing, verifying, and updating AWS SCT</a>. The process consists of three steps:</p>\\n<ol>\\n<li>Download the latest AWS SCT software for Microsoft Windows</li>\n<li>Extract the installer file</li>\n<li>Install it by opening the .msi file</li>\n</ol>\\n<h4><a id=\\"Download_JDBC_drivers_for_the_source_databases_52\\"></a><strong>Download JDBC drivers for the source databases</strong></h4>\\n<p>Download the required drivers for each of the source databases:</p>\n<ul>\\n<li><strong>Oracle driver</strong> – <a href=\\"https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html\\" target=\\"_blank\\">ojdbc8.jar</a></li>\\n<li><strong>SQL Server driver</strong> – <a href=\\"https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#72\\" target=\\"_blank\\">mssql-jdbc-7.2.2.jre11.jar</a></li>\\n<li><strong>IBM DB2 LUW driver</strong> – <a href=\\"https://www.ibm.com/support/pages/node/382667\\" target=\\"_blank\\">db2jcc-db2jcc4.jar</a></li>\\n<li><strong>SAP ASE driver</strong> – <a href=\\"https://www.sap.com/developer/trials-downloads/additional-downloads/sdk-for-sap-adaptive-server-enterprise-16-13351.html\\" target=\\"_blank\\">jconn4.jar</a></li>\\n</ul>\n<h4><a id=\\"Configure_JDBC_drivers_in_AWS_SCT_global_settings_61\\"></a><strong>Configure JDBC drivers in AWS SCT global settings</strong></h4>\\n<p>To configure your JDBC drivers, complete the following steps:</p>\n<ol>\\n<li>Launch your AWS SCT client</li>\n<li>On the <strong>Settings</strong> menu, choose <strong>Global settings</strong></li>\\n<li>Choose <strong>Drivers</strong></li>\\n<li>Choose <strong>Browse</strong> and choose the JAR file for each source database engine</li>\\n<li>Choose <strong>OK</strong></li>\\n</ol>\n<p>For more details or to download and install other database drivers, refer to <a href=\\"https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html#CHAP_Installing.JDBCDrivers\\" target=\\"_blank\\">Installing the required database drivers</a>.</p>\\n<h4><a id=\\"Configure_memory_settings_for_AWS_SCT_performance_74\\"></a><strong>Configure memory settings for AWS SCT performance</strong></h4>\\n<p>The AWS SCT assessment report can consume a large amount of memory, especially when you have many objects in a schema. The default allocated memory to AWS SCT is less than 1 GB. To avoid an <code>OutOfMemoryError</code>, you should allocate more memory to AWS SCT before you run the report.</p>\\n<ol>\\n<li>On the <strong>Settings</strong> menu, choose <strong>Global settings</strong></li>\\n<li>Choose <strong>Performance and memory</strong></li>\\n<li>Select <strong>Balance speed and memory consumption (experimental mode)</strong></li>\\n<li>Choose <strong>JVM options</strong></li>\\n<li>Choose <strong>Edit config file</strong></li>\\n<li>Choose <strong>OK</strong> on the confirmation page</li>\\n<li>Edit the file by adding two lines to the JavaOptions section. For example, if you have 16 GB memory available to your server, you can set the minimum JVM to 1 GB and maximum JVM to 12 GB.<br />\\n<code>Xmx12288M</code><br />\\n<code>Xms1024M</code></li>\\n<li>Save the file and restart AWS SCT</li>\n</ol>\\n<h4><a id=\\"Create_an_input_CSV_file_89\\"></a><strong>Create an input CSV file</strong></h4>\\n<p>AWS SCT accepts a connections file as input. In the file, you describe your source schema, server connection information, and target engines.</p>\n<p>The following is an example connections file in Excel. It shows the column values and syntax for Oracle, SQL Server, DB2, and Sybase as sources. The conversion targets are <a href=\\"https://aws.amazon.com/rds/aurora/mysql-features/\\" target=\\"_blank\\">Amazon Aurora MySQL-Compatible Edition</a>, <a href=\\"https://aws.amazon.com/rds/aurora/postgresql-features/\\" target=\\"_blank\\">Amazon Aurora PostgreSQL-Compatible Edition</a>, <a href=\\"http://aws.amazon.com/redshift\\" target=\\"_blank\\">Amazon Redshift</a>, and <a href=\\"https://aws.amazon.com/rds/mariadb/\\" target=\\"_blank\\">Amazon Relational Database Service (Amazon RDS) for MariaDB</a>.</p>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/433123fd9eaf47a7804647d3233e88b7_image.png\\" alt=\\"image.png\\" /></p>\n<p>Substitute the parameters with true values and save it as CSV file on your local computer.</p>\n<p>The following is an example created for this demo:</p>\n<pre><code class=\\"lang-\\">Name,Description,Secret Manager Key,Server IP,Port,Service Name,SID,Source Engine,Schema Names,Use Windows Authentication,Login,Password,Use SSL,Trust store,Key store,SSL authentication,Target Engines \\nOracle-app-1,,,&lt;hostip&gt;,1521,ORCL,,ORACLE,DMS_SAMPLE,,sctuser,&lt;loginuserpassword&gt;,,,,,AURORA_MYSQL;AURORA_POSTGRESQL;REDSHIFT\\nMSSQL-app-1,,,&lt;hostip&gt;,1433,,target_audience,MSSQL,dms_sample.dbo,,sctuser,&lt;loginuserpassword&gt;,,,,,AURORA_MYSQL;AURORA_POSTGRESQL;MARIA_DB\\nDB2-app-1,,,&lt;hostip&gt;,50000,,SAMPLE,DB2LUW,DB2INST1,,sctuser,&lt;loginuserpassword&gt;,,,,,AURORA_MYSQL;AURORA_POSTGRESQL\\nSYBASE-app-1,,,&lt;hostip&gt;,5001,,P1723126234,SYBASE_ASE,mydb.dbo,,sctuser,&lt;loginuserpassword&gt;,,,,,AURORA_MYSQL;AURORA_POSTGRESQL\\n</code></pre>\\n<h4><a id=\\"Run_the_multiserver_assessment_report_110\\"></a><strong>Run the multiserver assessment report</strong></h4>\\n<p>To run the multiserver assessment report, complete the following steps:</p>\n<ol>\\n<li>Launch AWS SCT</li>\n<li>On the <strong>File</strong> menu, choose <strong>New multiserver assessment</strong></li>\\n<li>For <strong>Project name</strong>, enter a name for your assessment project (for this post, Multiserver assessment1)</li>\\n<li>For <strong>Location</strong>, enter the directory where you want the reports to be generated</li>\\n<li>For <strong>Connections file</strong>, enter the full path for the CSV file you created</li>\\n<li>Choose <strong>Run</strong><br />\\nFigure 1 shows example entries for step 1 through step 6.</li>\n</ol>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/32a1999cfc494d8cb5ca20b6598d2ed3_image.png\\" alt=\\"image.png\\" /><br />\\nFigure – AWS SCT Multiserver assessment interface 1<br />\\n7. Choose Yes to proceed on the confirmation page as in Figure 2.</p>\n<p><img src=\\"https://dev-media.amazoncloud.cn/07414e8c6afa42fc84a762bba9cea79a_image.png\\" alt=\\"image.png\\" /></p>\n<p>Figure 2 – AWS SCT Multiserver assessment interface 2</p>\n<p>After the report runs successfully, a pop-up message appears with a button Open Report as shown by Figure 3.</p>\n<p><img src=\\"https://dev-media.amazoncloud.cn/1d80315bc36e48aa861417782a75e681_image.png\\" alt=\\"image.png\\" /><br />\\nFigure 3 – AWS SCT Multiserver assessment report run completed page</p>\n<h4><a id=\\"Locate_and_view_the_assessment_reports_138\\"></a><strong>Locate and view the assessment reports</strong></h4>\\n<p>AWS SCT builds a directory tree and saves the reports in each directory according to the parameters you entered earlier. In the following example, as shown by Figure 4, the AWS SCT reports are generated under \\t<code>c:\\\\Users\\\\Administrator\\\\AWS Schema Conversion Tool\\\\Projects\\\\Multiserver assessment1.</code></p>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/2b28ba91ddd04fdc8c6f43a142d05acf_image.png\\" alt=\\"image.png\\" /><br />\\nFigure 4 – AWS SCT Multiserver assessment report directory structure</p>\n<h4><a id=\\"Aggregated_report_145\\"></a><strong>Aggregated report</strong></h4>\\n<p>The aggregated report presents conversion complexity by each source schema and its targets. Conversion complexity is the level of difficulty to perform the migration to the target engine. 1 represents the lowest level of complexity, and 10 represents the highest level of complexity.</p>\n<p>For example, Figure 5 is part of the aggregated report. It shows the conversion complexity for each source schema targeting at Aurora MySQL and Aurora PostgreSQL. Based on this report, you may choose MySQL or PostgreSQL as the target engine for your Sybase and DB2 schemas because the complexity levels are low (equal to 1). However, for Oracle and SQL Server schemas, Aurora PostgreSQL may be a better choice because Aurora MySQL costs three times the effort compared to Aurora PostgreSQL.</p>\n<p><img src=\\"https://dev-media.amazoncloud.cn/c416e881c8f1445e82af5db557be6337_image.png\\" alt=\\"image.png\\" /><br />\\nFigure 5 – AWS SCT Multiserver assessment aggregated report</p>\n<h4><a id=\\"Specific_engine_assessment_reports_154\\"></a><strong>Specific engine assessment reports</strong></h4>\\n<p>In additional to the aggregated report, AWS SCT generates four reports for each specific source and target pair. For example, Figure 6 displays the files created for Oracle to Aurora PostgreSQL conversion.</p>\n<p><img src=\\"https://dev-media.amazoncloud.cn/1f1fc35ed1984b00bd1396e5660081d5_image.png\\" alt=\\"image.png\\" /><br />\\nFigure 6 – AWS SCT Multiserver assessment reports for a specific source and target engine pair</p>\n<p>AWS SCT assigns an <strong>Action item</strong> number to the conversion issues that can’t be resolved by AWS SCT automatically in the detailed CSV report. It then summarizes the number of occurrences and assigns a score for <strong>Learning curve efforts</strong> (effort needed to design an approach) and <strong>Efforts to convert an occurrence of the action item</strong> (effort needed to convert each action item, per the designed approach) in the summary report. See Figure 7.</p>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/9010a3e4c32e4735b768eaee05a1d71b_image.png\\" alt=\\"image.png\\" /><br />\\nFigure 7 – AWS SCT Action Items summary report for a specific source and target engine pair</p>\n<p>In Figure 7, action item 5025 in the packaged procedure \\t\\t\\t<code>SELLRANDOMTICKETS</code> has unsupported syntax. AWS SCT assigned 8 to the learning curve effort and 160 to the conversion effort for each occurrence. Compared to other items, it’s considered an expensive item because the scores for both columns are higher. You should plan accordingly to allocate more time to this item.</p>\\n<h4><a id=\\"Summary_168\\"></a><strong>Summary</strong></h4>\\n<p>In this post, we showed you how to configure and run an AWS SCT multiserver assessment report. We also demonstrated where to locate and view the reports. The multiserver feature allows you to mix and match your source and target engines so that you can get the most benefit from one process. AWS SCT aggregates and analyzes the action items, assesses the conversion effort for the entire schema as well as specific items, and presents these in a group of reports.</p>\n<p>You can use these estimates to efficiently plan ahead for your database migrations. We appreciate your feedback!</p>\n<h4><a id=\\"About_the_Authors_174\\"></a><strong>About the Authors</strong></h4>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/c6223f61aa2a49eab47e26d9e009646a_image.png\\" alt=\\"image.png\\" /></p>\n<p><strong>Shunan Xiang</strong> is a Senior Database Consultant with the Professional Services team at AWS. He works as a database migration specialist to help Amazon customers in design and implementing scalable, secure, performant, and robust database solutions on the cloud.</p>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/6289eede9563474390c6c90c23970bdd_image.png\\" alt=\\"image.png\\" /></p>\n<p><strong>Li Liu</strong> is a Senior Database Specialty Architect with the Professional Services team at Amazon Web Services. She helps customers to migrate traditional on-premise databases to AWS cloud. She specializes in database design, architecture and performance tuning.</p>\\n<p><img src=\\"https://dev-media.amazoncloud.cn/fe243a77f4bf4b61a6a3ceb6e5d4240c_image.png\\" alt=\\"image.png\\" /></p>\n<p><strong>Vaibhav Khandelwal</strong> is a Senior Product Manager with the [AWS Database Migration Service](https://aws.amazon.com/cn/dms/?trk=cndc-detail)s (AWS DMS) and AWS Schema Conversion Tool (AWS SCT) team. He leads the roadmap for AWS SCT and helps customers migrate and modernize their legacy database and analytics systems on AWS.</p>\n"}
目录
亚马逊云科技解决方案 基于行业客户应用场景及技术领域的解决方案
联系亚马逊云科技专家
亚马逊云科技解决方案
基于行业客户应用场景及技术领域的解决方案
联系专家
0
目录
关闭