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.

質問済み 4年前1165ビュー
1回答
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; 
回答済み 4年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ