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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      4 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • 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
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • Allow for retrying failed migrations

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

          6 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            5 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • 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
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

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

                  2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

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

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

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

                                      At Migration wizard, at target selection (Azure MySQL) failed to connect with error:
                                      Collector 'Microsoft.SqlServer.Migration.Core.MySql.Collectors.AzureDbMySqlServerPropertiesCollector' failed to collect data.
                                      ERROR [08S01] [MySQL][ODBC 5.3(w) Driver]Lost connection to MySQL server at 'reading final connect information', system error: 0

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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

                                          Azure Database Migration Service

                                          Feedback and Knowledge Base