DMS Max number of table threshold
Define DMS maximums and scripting migration activities
Tried to migrate a database the last few days a 3GB database with 4400 tables with DMS from an IaaS MSSQL server to Azure SQL, and it fails, the portal becomes unresponsive...
The pipeline failed to prepare table.... One or more errors occurred.The pipeline failed to prepare table ..... for bulk import.Cannot report data from 'SetResult' call , as the call threw an exception for scenario ...... The remote server returned an error: (400) Bad Request.The remote server returned an error: (400) Bad Request.
most tables failed after that..
however, when I select 500, 1000, 2000 tables, migration proceeds fine...
Just want to know what maximums we are allowed and can we script migration activities? that would be nice...
This is a known issue, we are working on addressing this. Meanwhile can you please distribute the tables (500 or so) into multiple projects and migrate?
Alvin Chang commented
We were actually able to migrate up to 2000 at a time.. Is there any way to script the table migration? or are we stuck with clicking on the interface?