Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

A simple guide to AWS SCT multiserver assessment

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. 



This post first appeared on Dba-ninja.com, please read the originial post: here

Share the post

A simple guide to AWS SCT multiserver assessment

×

Subscribe to Dba-ninja.com

Get updates delivered right to your inbox!

Thank you for your subscription

×