317 questions with Azure Database Migration service tags

Sort by: Updated
1 answer

Real-time Migration of Azure MySQL from One Tenant to another Tenant.

Hello Community, I am currently attempting to perform an online migration of Azure MySQL from one Azure tenant to another. I have explored multiple approaches, including: Azure Data Migration Service Azure MySQL Replication for Continuous Data…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
857 questions
asked 2024-11-18T12:01:48.2233333+00:00
Dorcas Ayodele 0 Reputation points
answered 2024-11-21T12:38:34.3466667+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
0 answers

Upload to Azure Migrate - Error AADSTS16000

I am using the latest version of Data Migration Assistant. Once I finish the assessment of a local SQL Server instance and try to upload the assessment to Azure migrate, I get this error after signing in to my Azure account. I can log into the portal and…

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
asked 2024-11-15T06:26:16.32+00:00
Agam Chauhan 0 Reputation points
commented 2024-11-21T05:49:05.9733333+00:00
Agam Chauhan 0 Reputation points
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…

Azure Database Migration service
Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,311 questions
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,495 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,943 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,911 questions
asked 2024-10-24T11:00:55.3666667+00:00
Magarde, A (Ankit) 0 Reputation points
commented 2024-11-04T14:47:01.6266667+00:00
AnnuKumari-MSFT 33,556 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.

Azure Database Migration service
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,244 questions
asked 2024-03-08T22:14:06.02+00:00
Alexander Rauenzahn 20 Reputation points
commented 2024-11-02T17:23:13.7433333+00:00
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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-10-21T17:04:51.1133333+00:00
Waleed Asad 5 Reputation points
commented 2024-10-30T17:44:36.9166667+00:00
Sai Raghunadh M 1,125 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:…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-10-25T11:31:52.5433333+00:00
Phatruethai Buaurai 0 Reputation points
commented 2024-10-29T13:25:20.64+00:00
Vijayalaxmi Kattimani 490 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…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
857 questions
asked 2024-10-21T23:54:26.0433333+00:00
이중문 0 Reputation points
commented 2024-10-24T12:44:38.7866667+00:00
NIKHILA NETHIKUNTA 3,505 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,…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-10-21T11:28:57.0666667+00:00
Elené Roos 0 Reputation points
commented 2024-10-24T11:50:11.88+00:00
Vijayalaxmi Kattimani 490 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…

Azure Database Migration service
Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
119 questions
asked 2024-08-02T18:55:23.06+00:00
Hossain, Shakir 21 Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT 19,571 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…

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,060 questions
asked 2024-10-20T09:57:32.11+00:00
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…

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,060 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
119 questions
asked 2024-10-16T12:12:27.3866667+00:00
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…

Azure Database Migration service
asked 2024-10-19T05:24:29.3+00:00
MannySo 25 Reputation points
commented 2024-10-23T04:49:24.9833333+00:00
MannySo 25 Reputation points
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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-09-18T00:40:12.2066667+00:00
NGUYEN HUNG CUONG 20 Reputation points
commented 2024-10-21T17:35:43.7966667+00:00
Sai Raghunadh M 1,125 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…

Azure Database Migration service
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
56 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
857 questions
asked 2024-09-12T12:22:42.91+00:00
Marc Hedgley 20 Reputation points
commented 2024-10-18T17:58:26.7566667+00:00
Mahesh Kurva 890 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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-10-16T14:53:30.6633333+00:00
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.

Azure Database Migration service
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
821 questions
asked 2020-08-19T07:22:05.727+00:00
Aditya MALKA 21 Reputation points
commented 2024-10-17T15:16:34.28+00:00
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…

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,060 questions
asked 2024-10-17T05:17:50.4733333+00:00
Hadi Burhan 80 Reputation points
answered 2024-10-17T09:04:45.43+00:00
ShaktiSingh-MSFT 15,766 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…

Azure Database Migration service
asked 2024-10-01T05:50:08.23+00:00
kuldeep Singh 0 Reputation points
edited a comment 2024-10-15T18:55:20.83+00:00
Mahesh Kurva 890 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…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
857 questions
asked 2023-09-05T06:30:44.19+00:00
Rakesh Dakornarayan Chandra 15 Reputation points
commented 2024-10-15T05:09:12.77+00:00
ShaktiSingh-MSFT 15,766 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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-09-24T07:32:34.39+00:00
Ivan Viskovic 15 Reputation points
commented 2024-10-09T07:30:46.05+00:00
Ivan Viskovic 15 Reputation points