Question: I have to prepare a report to assess the potential workload of converting SQL Server databases to AWS PostgreSQL targets. There are a large number of databases , so i'd like to identify if there is a method through the AWS toolset to create this report for multiple databases. I've been using the AWS Schema Conversion Tool (SCT) to create individual reports , but these are time consuming , as it has to be done one-by-one
Answer: Within the same tool you're using - AWS SCT - there is another option when you create a new project called "Mutiserver". The "Multiserver" option is available when you attempt to create a new Project.
An input file is required to list the source databases and related metadata . For a step-by-step guide check the AWS documentation on : CHAP_AssessmentReport.Multiserver.
Typical output will include:
1) A folder per database which will include all the changes recommended and in the same folder a summarised PDF document
2) When using the Multiserver option there will also be covering all the database with following columns & I'm also including some sample output .
Server IP address and port,Secret Manager Key,Name,Description,Database name,Schema name,Code object conversion % for "Amazon Aurora (PostgreSQL compatible)",Storage object conversion % for "Amazon Aurora (PostgreSQL compatible)",Syntax Elements conversion % for "Amazon Aurora (PostgreSQL compatible)",Conversion Complexity for "Amazon Aurora (PostgreSQL compatible)"
"127.0.0.1:50000","","DB1","","myDB1","myDB1.dbo","100.00%","100.00%","100.00%","1"
"127.0.0.2:50000","","Db2","","myDB2","myDB2.dbo","70.45%","100.00%","98.76%","2"
"127.0.0.3:50000","","DB3","","myDB3","myDB3.dbo","100%","100.00%","100.00%","1"
The final column "Conversion Complexity" details the level based on the effort of code conversion and migration. The number 1 is the lowest level , and the number 10 represents the highest level of complexity.