Azure Database Migration Service

Do you have an idea or suggestion based on your experience with Azure Database Migration Service? We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Database Migration Service customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Database Migration Service engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.

How can we improve Azure Database Migration Service?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Add support of Ad-hoc queries and ".trc" files to DMA analysis

    We would like to have DMA be able to analyze adhoc queries from application and SQL Profiler Traces (".TRC") files.

    26 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow for retrying failed migrations

    The service must allow for retrial (both automated and manual) of failed migrations.

    10 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Update Portal to cope with many databases

    The client-side script can currently not cope with many databases (500+) and the browser gets unresponsive due to script processing.

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Make the error message actionable "was suspended due to 8 successive recovery failures"

    I was able to get PostgreSQL activity to initialize after migrating the schema over from the source database. I have 1 table t1 with two columns c1 (pkey int), c2 (text) and 6 rows of data.
    After 23minutes I got the error "was suspended due to 8 successive recovery failures" and have no idea how to fix this.

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix Sync data validator to work with case sensitive collations

    Offline migrations seem to validate but online migrations on the business critical tier fail the data validation on databases with case sensitive collations like Latin1_General_CS_AS with the following error:

    { "resourceId":"/subscriptions/{subid}/resourceGroups/{my-rg}/providers/Microsoft.DataMigration/services/test-mydms", "errorType":"Error retrieving table information", "errorDetail":"Validator 'Microsoft.SqlServer.Migration.Core.Validators.SqlServerPKCDCSyncValidator' failed to validate data.Invalid object name 'information_schema.columns'." }

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support Migration from Azure SQL to Azure SQL Managed Instance

    Looking to migrate Azure SQL databases (.bacpac) to Azure SQL Managed Instance. Currently, I'm forced to export to .bacpac, import locally on VM, then export to managed instance. There has got to be a better way to essentially move databases from Azure SQL to Azure SQL Managed Instance.

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Improve message "The target database <name> is empty."

    For postgreSQL 9.5 Migration I'm getting The target database <database name> is empty when it initializes the DMS activity.

    I'm migrating to the target. It should be empty! What is it looking for that isn't there - the error message doesn't tell me how to fix this.

    Would love some help on this error and what DMS is expecting in the target.

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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...

    with error:
    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…

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. Cannot DMS trigger its own backups as needed for online migration?

    To avoid shared database folder setup issues (step #4 in the migration activity wizard) let the Azure DMS:
    a) create its own database backup folder (in its own VM I assume) for online database migrations, and
    b) save the required backups from the source SQL Server in this folder

    Reason: Currently I found the DMS migration settings in step #4 of the activity wizard confusing and problematic to have correctly configured. With each problem we resolved another one showed up. For example, now we noticed that our source SQL server does not have checksum enabled for existing backups; but the…

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Document SQL>SQLMI App credential rights

    When migrating SQL to SQL MI online it would be nice to know exactly the minimum rights or custom role configuration and where it needs to be applied in order to effectively migrate. For example you need 'Microsoft.Storage/storageAccounts/listKeys/action' on the storage account, you need Microsoft.Sql/locations/managedDatabaseRestoreAzureAsyncOperation/read on SQL MI etc.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Resume and retry backup upload

    Actually if database initial backup is being uploaded and a network glitch occurs the transfer fails as so the migration activity. As activities can't be retried either it is necessary to start all over again.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  12. add some information about proxy and Azure DatabaseMigrationAssitant

    Describe what can be made to allow the connection of the Azure DatabaseMigrantAssistant when you have a proxy on your network

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Increase the limitation of DMA activities

    why is there a limitation of 4 databases per activity and why does the activities get queued after you have 2 concurrent activities running at same time?

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Failed to connect to

    Error type
    Failed to connect, please check error details
    Error Detail
    Cannot read property 'properties' of null

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Ability to store definitions and re-run regular migrations - like environment refreshes

    Ability to store definitions and re-run regular migrations - like environment refreshes (e.g. for mongo CosmosDB), rather than having to define a new project and new task every time you want to copy data say from production to testing environments.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. I am receving the error while setting up the DMS.

    Hi All, I am receiving the error below for the DMS online option. I have validated the account permissions on the SMB share Azure share. Please assist.

    { "resourceId":"/subscriptions/e2f921a7-93af-477a-bbb4-2b8e233dc2d5/resourceGroups/Migration_PoC_CEA/providers/Microsoft.DataMigration/services/Dev6_TechM_Premium", "errorType":"Migration settings validation error", "errorDetail":"No valid full backup found for database 'EngagementDMS'." }

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. invalid handle

    Scenario: Migration SQL 2008 to SQL-MI using DMS

    I'm specifying a 2008 Windows SQL Server VM with file server enabled and a public share with everyone read/write. on Step 4 Configure Migration Settings I'm specifying \\ipaddress\public and getting "The handle is invalid."

    Any idea how to fix this?

    Error type - Migration settings validation error
    Error Detail

    Unhandled scenario exception. Scenario 'ValidateMigrationInput.SqlServer.AzureSqlDbMI.Sync.LRS', TaskId 'd2596a10-85b4-4a7c-9985-5d5f8b7cb032'.
    One or more errors occurred.
    Failed to collect backup information on network share '\\13.66.20.97\public' due to access failure.
    The handle is invalid.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. invalid password for a valid password

    I'm getting invalid password for a valid password. I set the account on the VM to postgresUser with installed version 10.6-1 (win 64) from EnterpriseDB.com. Don't know how to resolve this.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. Database migration error Unhandled scenario exception. Scenario 'Migrate.MySql.AzureDbForMySql.Sync', TaskId '2019ad11-151c-4665-9cd7-1e483

    Database migration error

    Unhandled scenario exception. Scenario 'Migrate.MySql.AzureDbForMySql.Sync', TaskId '2019ad11-151c-4665-9cd7-1e483b83ec4d'.
    One or more errors occurred.

    ERROR [HY000] [MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'xxxxxxxxxxxxxxxxxxxxxxxx (10060)
    ERROR [HY000] [MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'xxxxxxxxxxxxxxxxxxxxxxxxx' (10060)

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. DMS migration size error

    I keep getting the below error when trying to pass “Map to target databases” page in DMS project to migrate data from IaaS SQL DB to to PaaS DB. Could you please advise what is the problem and how to resolve it? Please email me directly for full details (subscription, resource group, etc.)

    { "resourceId":"/subscriptions/****/providers/Microsoft.DataMigration/services/***-DMS", "errorType":"Error retrieving table information", "errorDetail":"Unhandled scenario exception. Scenario 'GetUserTables.Sql', TaskId '92f76c13-8564-4840-8ab6-e4baf272b415'.One or more errors occurred.Cannot report data from 'SetResult' call , as the call threw an exception for scenario 'GetUserTables.Sql', task id '92f76c13-8564-4840-8ab6-e4baf272b415'.Exception during handling of the 'SetResult' notification from the agent.The update of scenario…

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Azure Database Migration Service

Feedback and Knowledge Base