Error metadata loading was interrupted because of data fetching issues

Question

Hi there,  
In an attempt to migrate a local MS SQL Server 2017 database of ~40GB to AWS RDS (Aurora in Postgres mode) I am getting error at the stage where the source database metadata discovery occurs:  
`Metadata loading was interrupted because of data fetching issues. For details, see the log`  
This happens fairly quickly, roughly after 20 sec. I use AWS SCT locally where the database resides using the latest JDBC drivers.

Answer

I perceive it as the SCT bug unable to proceed in case the collation of a database is different from the server instance.  
This is because I see this error in the log:

```
Error executing 'get-server-config' query: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
```

So my server was on the SQL_Latin1_General_CI_AS, but the database on the **Latin1_General_CI_AS** collation which is a valid setup in my view. Alas, the tool can't support this simple case.  
Remedied by

```
ALTER DATABASE 
COLLATE SQL_Latin1_General_CP1_CI_AS; 
```

Error metadata loading was interrupted because of data fetching issues

관련 콘텐츠