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…
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…
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…
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.
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…
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:…
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…
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 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…
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…
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…
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…
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…
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…
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…
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.
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…
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 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…
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…