AWS Schema Conversion Tool User Guide
By default, AWS SCT generates an aggregated report for all source databases and a detailed
assessment report for each schema name in a source database. For more information, see Locating
and viewing reports.
With the Create AWS SCT projects for each source database option turned on, AWS SCT creates
an empty project for each source database. AWS SCT also creates assessment reports as described
earlier. After you analyze these assessment reports and choose migration destination for each
source database, add target databases to these empty projects.
With the Add mapping rules to these projects and save conversion statistics for offline use
option turned on, AWS SCT creates a project for each source database. These projects include the
following information:
• Your source database and a virtual target database platform. For more information, see Mapping
to virtual targets in the AWS Schema Conversion Tool.
• A mapping rule for this source-target pair. For more information, see Data type mapping.
• A database migration assessment report for this source-target pair.
• Source schema metadata, which enables you to use this AWS SCT project in an offline mode. For
more information, see Using offline mode in AWS Schema Conversion Tool.
Preparing an input CSV file
To provide connection parameters as input for multiserver assessment report, use a CSV file as
shown in the following example.
Name,Description,Secret Manager Key,Server IP,Port,Service Name,Database name,BigQuery
path,Source Engine,Schema Names,Use Windows Authentication,Login,Password,Use
SSL,Trust store,Key store,SSL authentication,Target Engines
Sales,,,192.0.2.0,1521,pdb,,,ORACLE,Q4_2021;FY_2021,,user,password,,,,,POSTGRESQL;AURORA_POSTGRESQL
Marketing,,,ec2-a-b-c-d.eu-
west-1.compute.amazonaws.com,1433,,target_audience,,MSSQL,customers.dbo,,user,password,,,,,AURORA_MYSQL
HR,,,192.0.2.0,1433,,employees,,MSSQL,employees.%,true,,,,,,,AURORA_POSTGRESQL
Customers,,secret-name,,,,,,MYSQL,customers,,,,,,,,AURORA_POSTGRESQL
Analytics,,,198.51.100.0,8195,,STATISTICS,,DB2LUW,BI_REPORTS,,user,password,,,,,POSTGRESQL
Products,,,203.0.113.0,8194,,,,TERADATA,new_products,,user,password,,,,,REDSHIFT
The preceding example uses a semicolon to separate the two schema names for the Sales
database. It also uses a semicolon to separate the two target database migration platforms for the
Sales database.
Multiserver assessment report Version 1.0.672 278