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.

    25 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

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

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

          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

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

            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

              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

            • Allow for retrying failed migrations

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

              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

                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…

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