Error metadata loading was interrupted because of data fetching issues

0

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.

asked 4 years ago1119 views
1 Answer
0

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 <name>
COLLATE SQL_Latin1_General_CP1_CI_AS; 
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions