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 →
    • Support true Database Migration and creation from End-to-End

      Add support for the Azure Database Migration service to create the Azure SQL databases, schema and tables. It currently does not seem much like a migration services and seems more like the Azure SQL Data Sync (Preview).

      I would have expected the service to work like the Azure Site Recovery service that takes care of moving on-premises servers to Azure. This services takes care of everything from End-to-End.

      /Peter

      16 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'." }

          4 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

            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • DMS is working on production ???

            I try use DMS service convert my on-premise SQL Server to Azure Database managed instance.
            But still got the error when i choose
            [I will let Azure Database Migration Service create backup files]
            Failed to authenticate access to file share '\\x.x.x.x\demo'.
            Method failed with unexpected error code 53."
            And The System Event View show the error as below
            BackupDiskFile::OpenMedia: Backup device '\\x.x.x.x\demo\c456b2cd-44b5-4461-9c90-98fbde174e55.bak' failed to open. Operating system error 2(The system cannot find the file specified.).

            4 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

              under review  ·  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.

              4 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 →
                • Document the incredibly difficult set-up with examples of what needs to be configured in one document.Currently have 14 open docs, still not

                  There are more than 14 documents for a simple on-prem to Azure migration. After 2 days of trying I still cannot connect despite all the Vnets, firewall rules and all the resources that need creating. There are no examples in the documents for correct entries in fields to start a migration. It's a mine field and very frustrating when after 2 days of trying there is still "Server not found"

                  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

                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                    hello,
                    Sorry to hear your troubles using our service to migrate to Azure. I am wondering if you can reach out to us @dmsfeedback@microsoft.com, so that we can setup a working session with skype and walk you through your migration. As part of the exercise we can identify the avenues to fix our documentation as well to bring more clarity.
                    Please let us know what time that works for you and timezone as well.
                    Thanks
                    Raj Pochiraju
                    rajpo@microsoft.com

                  • 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.

                    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 →
                    • 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

                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SQL Backup File Not Being Deleted

                                    Afternoon all

                                    Quick question re the DMS if I may?

                                    I'm running some testing around migrating SQL Server databases hosted on a VM to SQL Server hosted on a VM, both within Azure, using the DMS. The process works fine but I am receiving the following error (although it's not actually flagging it as an error or a warning, I only see this when I click on the individual database migration status'):

                                    "Failed to delete 1 out of 1 files from \\server\backup.
                                    Failed to delete backup or restore file '\\server\backup\2bpikijh.o5m.bak' on share '\\server\backup'.
                                    The network path was not found."

                                    Is…

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

                                    Azure Database Migration Service

                                    Feedback and Knowledge Base