Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
315 questions
1 answer
Copy activity failed because you have multiple concurrent copy activities runs writing to the same file
Hi All, I am migrating 1000 of SQL tables from on premise SQL server to Azure Blob storage. I am using ADF for each and copy activity to do so. However, while processing the tables in parallel/concurrent, I am getting below error - Failure happened…
asked 2024-10-24T11:00:55.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 27%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Magarde, A (Ankit)
0
Reputation points
commented 2024-11-04T14:47:01.6266667+00:00
AnnuKumari-MSFT
33,476
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How do I resolve this message: Management operations are not allowed until migration is committed or aborted.?
I am performing a migration for Classic Storage Accounts to Azure Resource Manager, and on one of my Accounts, I am getting this message: Management operations are not allowed until migration is committed or aborted. I am unsure how to resolve this.
asked 2024-03-08T22:14:06.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alexander Rauenzahn
20
Reputation points
commented 2024-11-02T17:23:13.7433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 59%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Robert Keith
1
Reputation point
0 answers
Permission Denied in table 'xxx' Issue After Migrating from Single Server to Flexible Server in Azure PostgreSQL
Hello Microsoft Support Team, I am reaching out to request assistance with an issue I encountered after migrating my PostgreSQL database from Single Server to Flexible Server in Azure. After completing the migration, I am unable to execute queries, as I…
asked 2024-10-21T17:04:51.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 31%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
Waleed Asad
5
Reputation points
commented 2024-10-30T17:44:36.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
0 answers
How to fix Error 603413: Unsupported language(s). in Azure DMS
i try to use Azure DMS (new version) migration from AWS RDS PostgreSQL version 15.6 to Azure Azure Database for PostgreSQL - Flexible Server version 16.4 which when i choose validation and migrate it cannot success and show this errors : Error 603413:…
asked 2024-10-25T11:31:52.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Phatruethai Buaurai
0
Reputation points
commented 2024-10-29T13:25:20.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
MySQL Single to MySQL Flexible Server Change
It appears that the mysql single server used for my subscription account has been EOSed and forced to migrate to mysql flexible server. However, "Azure Database for MySQL flexible server 'psnm-mcs-p-db-mysql' has been migrated standalone to…
asked 2024-10-21T23:54:26.0433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 8%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
이중문
0
Reputation points
commented 2024-10-24T12:44:38.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,265
Reputation points Microsoft Vendor
1 answer
The migration to Azure Database for PostgreSQL Flexible Server is in progress
Got a surprise this morning, where 2 of my Azure Single Server PostgreSQL instances were in migration progress. The problem is, it is affecting my dev and prod env which means the DB is stuck in read-only mode. I can't see any progress on the migration,…
asked 2024-10-21T11:28:57.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 20%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Elené Roos
0
Reputation points
commented 2024-10-24T11:50:11.88+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
0 answers
Azure Managed Instance Migration offline mode. Cannot find full back up error
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…
asked 2024-08-02T18:55:23.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hossain, Shakir
21
Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Guidance with MariaDB migration to Azure SQL Server
Hello, I am currently working on migrating a MariaDB database hosted on AWS to Azure as part of a cloud consolidation program. While Azure Database for MariaDB seemed like a natural choice, Microsoft's planned retirement of this service by 2025 has led…
asked 2024-10-20T09:57:32.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marc Hedgley
165
Reputation points
commented 2024-10-23T07:31:33.98+00:00
Marc Hedgley
165
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL server databases migration to Azure SQL VM using Azure Data studio
Hello, I am migrating the SQL server databases to Azure SQL VM using Azure data studio but step 6 - validating the connectivity failed with below error. I am able to connect to SQL server using SSMS from same server. I can be able to see the…
asked 2024-10-16T12:12:27.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjeev Koppella
20
Reputation points
accepted 2024-10-23T04:51:09.07+00:00
Sanjeev Koppella
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I can create a new table in a database already made empty. VB 20017 SQL Express
I am learning Visual Basic 2017, and I created an empty database without a table. So, now I would like to learn how to add a table to the new database. The database that I created is SQL Express, and I am using ADO.net. There is somebody in here who can…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
PostgreSQL Flexible Server Not Appearing After Automatic Migration
Hello, My Azure Database for PostgreSQL Single Server was scheduled for migration to an Azure Database for PostgreSQL Flexible Server on August 31, 2024. However, the old PostgreSQL Single Server has now been deleted, and I am unable to locate the new…
asked 2024-09-18T00:40:12.2066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
NGUYEN HUNG CUONG
20
Reputation points
commented 2024-10-21T17:35:43.7966667+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
2 answers
Guidance with MariaDB migration to Azure
Hello, I am currently looking at migrating a MariaDB database hosted on AWS over to Azure as part of a cloud consolidation program. While Azure Database for MariaDB would seem like the most suitable choice, Microsoft has announced that this service will…
asked 2024-09-12T12:22:42.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marc Hedgley
20
Reputation points
commented 2024-10-18T17:58:26.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
805
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
PostgreSQL Single server to Flexible server fails on BYPASSRLS
Hello, We're using the Azure Database Migration service to migrate our Azure PostgreSQL Single server to a Flexible server. It fails with the following message: "Failed to execute query `ALTER ROLE "dummyAdmin" WITH BYPASSRLS;` with…
asked 2024-10-16T14:53:30.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 32%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Niels Delestinne
25
Reputation points
edited a comment 2024-10-18T07:31:41.5033333+00:00
Niels Delestinne
25
Reputation points
1 answer
One of the answers was accepted by the question author.
how to migrate data from on-premise sql server to azure postgresql
we have tried to migrate data from on-premise SQL to azure PostgreSQL by using database migration service but we are not able to select target as PostgreSQL when source is SQL server.
asked 2020-08-19T07:22:05.727+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aditya MALKA
21
Reputation points
commented 2024-10-17T15:16:34.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOT%3C/text%3E%3C/svg%3E)
Onoja, Treasure
0
Reputation points
1 answer
Migration From Physical SQL Server Windows 2012 To Azure
Hi All, I have a On prem physical SQL Server running windows 2012. I have site to site connectivity already establishes. The SQL Server is running ABOUT 30 DB. Our goal is to completely migrate the DB so we can decommissions the on prem server. I…
asked 2024-10-17T05:17:50.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hadi Burhan
80
Reputation points
answered 2024-10-17T09:04:45.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,501
Reputation points
1 answer
Monitoring and alerting setup on the Taks (Online data migration) of service Azure Database Migration Services ?
Hi Team, I have a Azure Database Migration Services in which i have created Azure Database Migration Project under that we have Three Online data migration tasks which sync db from aws to azure. but when anyone of task is getting failed am not getting…
asked 2024-10-01T05:50:08.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 26%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
kuldeep Singh
0
Reputation points
edited a comment 2024-10-15T18:55:20.83+00:00
Mahesh Kurva
805
Reputation points Microsoft Vendor
1 answer
Azure MySQL single server got auto migrated to flexible server
I have an Azure MySQL single server which got auto migrated to flexible server and currently in stopped state because of which I can't change any settings or can't access it from any client application, when opening in azure portal its showing message…
asked 2023-09-05T06:30:44.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dakornarayan Chandra
15
Reputation points
commented 2024-10-15T05:09:12.77+00:00
ShaktiSingh-MSFT
15,501
Reputation points
2 answers
Can't see or access database server after automatic migration
After automatic migration of our Postgres single database servers to flexible servers that started 14.09. and lasted until 20.09. i can't see new database servers in my resource group. I can access database through power shell but not from the…
asked 2024-09-24T07:32:34.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 85%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIV%3C/text%3E%3C/svg%3E)
Ivan Viskovic
15
Reputation points
commented 2024-10-09T07:30:46.05+00:00
Ivan Viskovic
15
Reputation points
2 answers
One of the answers was accepted by the question author.
What are some different methods to restore/copy/migrate Azure SQL Database across subscription and across the server?
I'm just trying to access different methods to migrate my SQL database from one subscription to another
asked 2022-02-11T15:23:14.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek-MSFT
181
Reputation points Microsoft Employee
commented 2024-09-23T08:47:34.9433333+00:00
Žarko Jovanović
0
Reputation points
1 answer
Does it possible to move a MySQL database between different Azure Accounts?
Hi all, I have 2 different Azure Accounts. I want to move the mysql database in one of these Azure accounts to my other Azure account. Since the database is approximately 150 GB, I would like to do this with the Azure recommended or best practice method…
asked 2024-09-17T15:11:59.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 36%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Bekir Faruk
0
Reputation points
answered 2024-09-23T03:11:21.2333333+00:00
ShaktiSingh-MSFT
15,501
Reputation points