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.

  1. support for 15

    When Creating a Hybrid DMS project, I get this error

    { "resourceId":"/subscriptions/ae474c60-9cda-46c6-b554-83dbb6135cf7/resourceGroups/fin-int-db-rg/providers/Microsoft.DataMigration/services/testint-ms", "errorType":"Failed to connect, please check error details", "errorDetail":"The version of the server 15.0.2070.41 does not fall in the range of supported versions [9, 14]. Please refer to the list of supported source server versions and editions. https://go.microsoft.com/fwlink/?linkid=867939" }

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Upload DMA assessment(s) to Migrate Hub using CLI

    When you are performing assessments on several instances and you would like to to consolidate the upload to Azure Migrate Hub, it is now a bit clunky. The only way to do it is using the UI and one at a time.
    It would be very practical to be able to use the CLI to upload your assessment files. Hopefully this can be done the with the resultfiles for consolidated scaled assessments as well.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support migration from RDS Postgres to Azure Postgres

    Validator 'Microsoft.SqlServer.Migration.Core.PostgreSql.Validators.PostgreSqlDatabaseSchemaMatchValidator' failed to validate data.
    An item with the same key has already been added.

    What's the meaning of this error?

    Please, I hope you can help me.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. failed to initiate with the following errors. { "resourceId":"/subscriptions/78fdb285-3be2-4fc5-ae77-9aba5342420f/resourceGroups/CNV/provid

    FAiled to initiate the DMS. This happening at the last step but validation success at source and target details when provided.

    { "resourceId":"/subscriptions/78fdb285-3be2-4fc5-ae77-9aba5342420f/resourceGroups/CNV/providers/Microsoft.DataMigration/services/Boeing", "errorType":"Migration settings validation error", "errorDetail":"Error -1000 - failed to establish connection to the host on the specified port.External component has thrown an exception." }

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 4.2.0

    Can not migration mongodb to cosmosdb

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Failed to download the file. Error details: error 403 Server failed to authenticate the request. Make sure the value of Authorization header

    Im trying to download the "Installer" from Data Migration Services but it throws an error.
    "Failed to download the file. Error details: error 403 Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature."

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Please check if the on premise services are running under domain accounts

    ADMS should check if the services are running under special domain accounts in stead of local accounts. Those will be possible blocking issues

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Migration Wizard failed to connect to target

    At Migration Wizard, at target selection (Azure DB for MySQL) "errorType":"Failed to connect, please check error details", "errorDetail":"Cannot read property 'properties' of null"

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Increase the number of sources for migration example Teradata, DB2

    Teradata is such a renowned Datawarehouse and so is DB2 a well known database. Please include these sources for database migration. Most enterprises use these systems

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Remove Truncate Table from DMS Online Migration

    Please remove Truncate Table commands from the online migration process for tables in the target DB that are already empty.

    Online Migration is trying to truncate tables that have foreign keys - even though the tables are empty in the destination.

    This is breaking our online migration. We have about 2500 foreign keys in our schema.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add backticks to FK Name in generated drop FKs script for MySQL

    The generated script per https://docs.microsoft.com/en-us/azure/dms/tutorial-mysql-azure-mysql-online?source=docs to drop the FKs will fail when the name of the FK has a dot (.) in the name.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Improve Memory-optimized filegroup must be empty error message

    Improve how to solve the error message:

    Memory-optimized filegroup must be empty in order to be restored on General Purpose tier of SQL Database Managed Instance.

    RESTORE DATABASE is terminating abnormally.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. JSONB support for postgresq migration

    Currently DMS does not support jsonb data types, we are heavily using it in production and because of this limitation we are unable to migrate.
    When will you support jsonb and do you have temporary solution for this?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add Support for Blob as source

    Add support for using Azure Storage as the backup source location.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. URGENT: Facing a problem on (Variable binlog_format has value 'mixed'. Please change it to 'row'.)

    I have already updating variable binlogformat value 'mixed' to 'row'. And also variable binlogchecksum value set as NONE. And reboot my aws rds instance. Still I m getting same error (Error in binary logging. Variable binlog_format has value 'mixed'. Please change it to 'row'. ) when migrate aws rds on azure database mysql.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. [71501] Unresolved references found - Need to stop reporting this error when system objects are referenced by user object

    We have a client with over 5000 databases and the number 1 reported blocker is [71501] Unresolved references found with over 100K instances! However, the vast majority of these issues are not a problem at all. It looks like DMA doesn't know how to resolve references to system tables and views.

    Here is an example:

    View: [PRUtility].[ObjectCatalog] has an unresolved reference to object [sys].[triggers]. For more details, please see: Line 69, Column 9.
    View: [PR
    Utility].[ObjectCatalog] has an unresolved reference to object [sys].[indexes]. For more details, please see: Line 53, Column 9.
    View: [PR_Utility].[ObjectCatalog] contains an unresolved reference to…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Source on-premise connection to Sql server failing in DMS

    Error type
    Failed to connect, please check error details
    Error Detail
    Error 53 - SQL connection failed.

    Please use this interactive user guide to troubleshoot the connectivity issue: https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    The network path was not found

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. port the DocumentDB data migration tool to Unix Platform targeting Linux and MacOS

    Document DB Migration tool is only available for Windows Platform, my whole organization is using mac, just for using this tool I have to spin a Windows VM , In general for wider adoption and ease the tool needs to be available for other platforms such as unix

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Azure Database Migration Service

Categories

Feedback and Knowledge Base