Moves the specified database from its current managed SQL Server instance to another server.

The MOVE_DATABASEjob may be skipped or rejected if the database is larger than 500 GB.

If a second MOVE_DATABASE job is submitted for the same database before the first job is complete, the first workflow job takes precedence. May return validation errors include attempting to move a database that was deleted before the job reaches the service, or conflicting delete-after-move scenarios as enforced by the server.

If successful, adds a MOVE_DATABASE job to the workflow queue and returns a 202 Accepted HTTP status code. The ID of the job is returned in the Location header of the response. Use the Get Admin Job operation to poll the status of the job.

🍐

Permissions

To perform this operation, a principal must belong to a user group that has been assigned the Data Admin role.

To learn more about role-based permissions, see Access Controls.

/platform/admindata/v1/databases searchdatabases databaseId, databaseName, databaseType, serverType, serverName, customServerName, securableId, securableType, securableName, sizeInMb, owner, createDate, lastModified.