I am looking to migrate some databases (in Terabytes) from oracle, MS SQL and Sybase to PostgreSQL I came across - SCT as one of the tools which might be useful I have a few questions regarding the viability and ability of SCT for the task:
Questions:
The AWS Schema Conversion Tool only converts the schema. It does not transfer the data.
From What Is the AWS Schema Conversion Tool?:
You can use the AWS Schema Conversion Tool (AWS SCT) to convert your existing database schema from one database engine to another. You can convert relational OLTP schema, or data warehouse schema. Your converted schema is suitable for an Amazon Relational Database Service (Amazon RDS) MySQL, MariaDB, Oracle, SQL Server, PostgreSQL DB, an Amazon Aurora DB cluster, or an Amazon Redshift cluster. The converted schema can also be used with a database on an Amazon EC2 instance or stored as data on an Amazon S3 bucket.
To transfer the data, you could use the AWS Database Migration Service (AWS DMS).
From What is AWS Database Migration Service?:
AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups.
The Schema Conversion Tool can convert triggers, but please consult the documentation for capabilities/limits.
The Schema Conversion Tool is free. See: Installing, verifying, and updating the AWS SCT
The Database Migration Service involves a server, so it is has associated costs. See: AWS Database Migration Service Pricing - Amazon Web Services