Error loading metadata using AWS SCT against an RDS SQL Server Instance
I am trying to use the AWS Schema Conversion Tool to convert a SQL Server instance running on RDS to Aurora MySQL. I have a large number of databases in the same SQL Server instance, and was able to successfully convert the schema for 5 of them. Then I attempted to use the "Refresh from Database" menu option for one of the databases and received an error stating
Metadata loading was interrupted because of data fetching issues. For details, see the log.
On checking the logs, I see the following error that is causing the issue:
Error executing 'load-script-object-ext-properties' query: com.microsoft.sqlserver.jdbc.SQLServerException: Collection specified does not exist in metadata : 'sys'
Now I am unable to see the schema of any database on that server, and they ALL fail with the same issue.
I have tried creating a new SCT project, and using a different SQL login.
I am completely blocked at the moment, and not sure how to progress my migration.
Hi, Thank you for reaching out. Looking at the error from the log: its throwing a SQL Server exception listed here: https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver15 This script "load-script-object-ext-properties” could be getting invoked by SCT menu "Refresh from Database”.
You can try to connect to SCT through master user of the SQL Server database and see if you are able to see the schemas of any database. In addition, if you have not already granted the permission required, please do so by repeating the grant for each database as mentioned here: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Permissions
If the above does not help, as a test, please try to create a sample database and a table with master user of your RDS SQL Server instance and check if you are able to view the schemas then.
In order to further help you with this issue, we require details (such as complete log) that are non-public information. Please open a support case with AWS using the following https://console.aws.amazon.com/support/home#/case/create.
Sometimes, a simple fix by DISCONNECTING from the SOURCE-database and creating a new SOURCE-Connection will fix such problems within SCT.
Error loading metadata using AWS SCT against an RDS SQL Server Instanceasked 5 months 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 13 days ago
DMS to migrate SQL Server from RDS to EC2asked 2 years ago
Error while connecting to SQL Server Express Edition from SCTasked 10 months ago
Error when trying to add db instance to VS server explorerasked 3 years ago
Is there a service to move a database from MSSQL to MySQL (both hosted on AWS)asked 3 months ago
Error metadata loading was interrupted because of data fetching issuesasked 2 years ago
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?asked 7 months ago
What's a MS SQL "named instance" ?Accepted AnswerEXPERTasked a year ago
SSL connection has been closed unexpectedlyasked a year ago