AWS Schema Conversion Tool - Troubleshooting a Connection Error?

0

I have a security / permission / connection problem using SCT.

I'm using SCT locally to migrate my SQL Server DB to an Aurora DB in AWS. I get a "Connection wasn't established. Check connection properties." error. The log file is no use, all it has is a caught Java exception and stack trace: "com.amazon.sct.dbloader.exceptions.DbLoaderHandledException".

I created the Aurora DB with public access.

In SCT my connection details are:

Server name: mobile-reports-instance-1.c9vuf469uzhv.us-east-1.rds.amazonaws.com

Port: 5432

Database: I tried both regional cluster, "mobile-reports-instance-1" and writer instance names: "mobile-reports"

Username: postgres

And the correct passsword.

How can I troubleshoot this? I have no information to go on. Do I need to add an internet gateway to my DB or is that done when I select "allow public access"?

neohed
已提問 2 年前檢視次數 1089 次
1 個回答
0

It looks to me like you haven't installed the postgresql driver.
Install the SQL Drivers and AWS Schema Conversion Tool on Your Local Computer

This frustrated me for a couple hours a few months ago. I found these step by step walk throughs very useful. Database Migration Step-by-Step Walkthroughs

profile pictureAWS
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南