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. 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 →
  2. Highlight use of sequence object during schema migration

    Sequences are not supported with replication. They are not created by a schema migration, this makes sense as how should it be seeded prior to a migration.

    I suggest that usage of sequence objects within a schema should be highlighted during an schema migration so that alternative steps can be taken.

    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. Need a collection/table comparison feature within the app

    Anything that would compare source and destination and yield differences would be great. This could then be used to validate data migrations for sensitive data when migrating to Cosmos.

    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 →
  4. Database Migration Service create fails with Chrome

    Never becomes available and stays grayed out. See attached file. Works with Safari on Mac!

    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. How do you identify PUID for a failed restore DB when activity has failed

    we have had several instances where the ADMS activity is in a failed status and when we delete the activity related to the failure the target DB does not get deleted causing issues where if we need to re-initiate the DB migration; it doesn't allow the setup because the DBs exist on the target.
    1. How do you identify the DB name related to the PUID
    2. How do you delete the DBs in restorind mode where DB name = PUID

    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 →
  6. 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…)
    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. 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…)
    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. 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/MigrationPoCCEA/providers/Microsoft.DataMigration/services/Dev6TechMPremium", "errorType":"Migration settings validation error", "errorDetail":"No valid full backup found for database 'EngagementDMS'." }

    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 →
  9. 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…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. CosmosDB to CosmosDB database migration support

    We need to migrate collections from one CosmosDB to another CosmosDB account with minimal effort

    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 →
  11. 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…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…

    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 →
  14. DMS migration validation error.

    DMS migration validation error.

    smb install & authorization

    sourcedb : 40.74.85.154

    sharefolder : SQLServerBackups in sourcedb

    VM login id : head1ton

    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 →
  15. When we create a new project we get an eroor

    Error type
    Service Unavailable
    Error Detail
    The service failed to start, please contact Microsoft support

    1 vote
    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 →
  16. Allow me to use my MSDN subscription to test this

    I can't follow the tutorial or test this out when using my MSDN Azure subscription ... E5 level. This is what I see (see attached). Anyone know what subscription I need to have or if this is a bug? I could not find help in the documentation.

    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 →
  17. Migration settings validation error

    The service returns an error:

    Failed to authenticate access to file share '\40.112.66.219\Backup'.

    Method failed with unexpected error code 53.
    

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Replicate Azure Databases to Azure Databases (mysql and Postgressql

    Will be great has a replication service to have a clone of you database on other location, if this works like master-***** replication Azure to Azure PaaS

    0 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 →
1 3 Next →
  • Don't see your idea?

Azure Database Migration Service

Categories

Feedback and Knowledge Base