What the SQL version did you use? The on-premises solution must use SQL Server 2016 or a later version, and the database must have compatibility level 130 or higher. The on-premises solution must also be one of the supported versions.
When migrating data from Business Central on premise, check the applicationVersion field in the $ndo$tenantdatabaseproperty table. Set this field to the correct version in the SQL if it's blank or not up to date. If that table field mentioned above is blank, the migration cannot run.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.