The Server Name for Redshift in the AWS Schema Conversion Tool is usually the Redshift endpoint without the port number and the database name.
The endpoint can be found on the Redshift console => clusters => click on the appropriate cluster => General Information => Endpoint.
Also make sure that the Redshift Security Group accepts the necessary connections (inbound rules).
You can find on the following link the Step-by-Step migration process https://docs.aws.amazon.com/dms/latest/sbs/chap-rdsoracle2redshift.steps.html
Amazon Schema Conversion Tool Connection error with Redshift as target databaseasked 3 months ago
Database migration from SAP HANA to Redshiftasked 8 months ago
Redshift Data Share External Schemaasked 2 months ago
Does SCT support converting Oracle View to Redshift View?asked 6 months ago
Can SCT be used to auto generate a data migration when both source and destination schemas exist yet they are different engine types?Accepted Answerasked a year ago
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 7 months ago
AWS Schema Conversion Tool - Troubleshooting a Connection Error?asked 4 months ago
ETL Replication from Oracle to Postgresasked 5 months ago
Database Migrationasked 3 months ago
Where are the options supported by AWS Schema Conversion Tool.cfg?Accepted Answerasked 2 months ago