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:
- Is AWS SCT able to migrate databases (Data and Schema both) from Oracle, MS SQL and Sybase to PostgreSQL ?
- Is AWs SCT able to migrate Triggers, Queries, Views and Stored Procedures ?
- Does this migration happen on-premises or I will have upload/transfer to upload my data to AWS cloud compute or S3 instances, migrate/convert and download back ?
- What is the largest database size that can be migrated using AWS SCT (Giga/Terabytes/Records) ?
- How fast is the database migrated (Data per Time) ?
- What is the accuracy of the migration (Percent) ?
- how do I use the AWS SCT tool ? ( example: Is it available for public download? Are there any Paid licenses? Does it come bundled with some other service which we have to buy? )
- I would also appreciate if there is any extra information about AWS services which might help my project.
The AWS Schema Conversion Tool only converts the schema. It does not transfer the data.
From What Is the AWS Schema Conversion Tool?:
To transfer the data, you could use the AWS Database Migration Service (AWS DMS).
From What is AWS Database Migration Service?:
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