Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
313 questions
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
![](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,326
Reputation points
4 answers
One of the answers was accepted by the question author.
Unable to Delete Azure Virtual Network
I am attempting to delete an Azure virtual network but keep receiving the error message: "Failed to delete virtual network ''. Error: Subnet iat-5e5de8a6ba-dbsubnet is in use by…
asked 2023-12-15T15:51:26.79+00:00
Jorge Insfran
20
Reputation points
commented 2024-10-10T11:06:37.4766667+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(70.4, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Mykhailo Vasylchenko
0
Reputation points
1 answer
One of the answers was accepted by the question author.
What is the difference between Server less SQL and SQL Database?
When I use sever less SQL with Azure Synapse Analytics, it provided me an endpoint, And when I use that endpoint in Power Bi, and Microsoft SQL Server Management Studio it shows that A Database is there and show me all files, but when When I use Azure Ai…
asked 2024-10-07T08:12:44.8466667+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(240, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lovedeep Singh
165
Reputation points
accepted 2024-10-10T07:22:19.9066667+00:00
Lovedeep Singh
165
Reputation points
1 answer
Can't delete virtual network or subnet due to Service Association Link (SAL)
Hi, I'm getting below error while deleting the VNET. Failed to delete virtual network ''. Error: Subnet strapi-demoDbSubnet is in use by…
asked 2024-09-15T15:37:05.63+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(118.4, 84%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQT%3C/text%3E%3C/svg%3E)
Quan Truong
0
Reputation points
commented 2024-10-10T01:58:09.49+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(204.8, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Prasanna Sinde (Quadrant Resource LLC)
765
Reputation points Microsoft Vendor
1 answer
Internal server error while creating azure mysql server
{ "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
asked 2024-07-31T16:14:29.7766667+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(204.8, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Dev Ops
0
Reputation points
commented 2024-10-09T22:02:28.24+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
1 answer
How to fix ERROR 1045 (28000): Access denied for user 'ecommerceapp@mydbserver1'@'myip' (using password: YES)
Hello, I am using Windows 10. I have an Azure Database for MySQL flexible server that I can successfully connect to using my local MySQL workbench. However, when I use mysql -h
asked 2024-10-09T00:19:39.14+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(54.400000000000006, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
Wenbo Peng
0
Reputation points
answered 2024-10-09T04:51:24.8066667+00:00
ShaktiSingh-MSFT
15,326
Reputation points
1 answer
Can Write To Azure SQL Database, Cannot Read
I am so confused on this one. I have been able to write to my Azure Database for MySQL flexible server using python, it works no problem, it uploads my data and I can see the new tables and I can actually read those tables on my wix website no problem. I…
asked 2024-10-03T02:53:54.4333333+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(64, 59%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Josh Barth
0
Reputation points
commented 2024-10-07T17:47:02.24+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
265
Reputation points Microsoft Vendor
1 answer
Possible MySQL database data loss
Hello, We noticed some of our records in the database are missing. We send SMS thourgh our backend and keep the logs in the database. We noticed some people have received our SMS but I don't see any records in the database for them. It is not…
asked 2024-10-01T10:11:15.0566667+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(182.40000000000003, 96%, 27%)' 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)
S Mahdi Seifollahi
0
Reputation points
commented 2024-10-04T18:47:47.5366667+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
645
Reputation points Microsoft Vendor
0 answers
How to get Employees Hierarchy
Hi, My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP. Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7…
asked 2024-09-30T17:48:51.62+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(291.2, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
vandana
0
Reputation points
commented 2024-10-04T17:24:58.3266667+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
2,790
Reputation points Microsoft Vendor
1 answer
Retrieve correct information about publicNetworkAccess for Azure MySQL flexible server
Hi! I'm using the rest api to retrieve information abot Azure Database for MySQL flexible server. In particular, I'm using this endpoint to list all the servers:…
asked 2024-09-27T17:38:21.8666667+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, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gonzalo Avalos Ribas
0
Reputation points
commented 2024-10-04T15:30:40.86+00:00
Mahesh Kurva
265
Reputation points Microsoft Vendor
0 answers
How do I access PHPmyadmin in WordPress as App Service (Linux) with Managed Identities turned on?
Hello Community, We need to access PHPmyadmin to manage our MySQL Database used for WordPress. We are using Standard Hosting Plan of Azure with WordPress on App Service (Linux based) with Managed Identities activated. Now the issue is that we are not…
asked 2024-09-10T20:01:20.3033333+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, 22%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Saima Adeni
10
Reputation points
edited a comment 2024-10-04T04:32:31.51+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(153.6, 92%, 24%)' 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)
ajkuma
26,221
Reputation points Microsoft Employee
2 answers
Azure SQL Server Single instance auto migration authorization not saving (Spinning)
Auto-migration authorization is not saving and just spinning. Cannot save these changes to have microsoft to migrate our SQL database
asked 2024-09-24T18:46:49.87+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(246.4, 46%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nisarg Shah
0
Reputation points
commented 2024-10-01T19:38:54.06+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
1 answer
DB Connection Failed SQLSTATE[HY000] [2002]
Hello All, We have azure web app with Linux OS, php 7.4 stack, publish mode is code and we are using default domain over the same. We are trying to connect the same with MYsql flexible server (Business Critical, E2ads_v5, 2 vCores, 16 GiB RAM, 100 GiB…
asked 2024-09-17T04:05:43.1833333+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(310.4, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
10
Reputation points
answered 2024-09-30T09:24:54.83+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, 92%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Videsh Lingabavan
0
Reputation points
1 answer
Metrics - Resource not found message
When creating a new chart Im getting the following error: Resource not found
asked 2024-09-25T00:32:09.5966667+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(211.20000000000002, 68%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Soltec Soltec
0
Reputation points
answered 2024-09-27T16:43:45.46+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(281.6, 0%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
youzeliang
735
Reputation points
2 answers
One of the answers was accepted by the question author.
Error on sink data to MySQL - communications link failure
I've got a Pipeline with some Data Flow activities that runs in parallel. I've got the error on last night's execution and I'd like some help to understand why and how to prevent it from happenning. Job failed due to reason: at Sink 'EnviaFerias':…
asked 2024-09-19T11:24:37.3633333+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(291.2, 25%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Joffre L. A. Mota (LG lugar de gente)
25
Reputation points
accepted 2024-09-27T11:19:59.9+00:00
Joffre L. A. Mota (LG lugar de gente)
25
Reputation points
1 answer
Azure Mysql flexible server - reduce storage size by purging binlog via binlog_expire_seconds
I have set the server parameter binlog_expire_seconds to 30 in Azure mysql flexible server. I was trying to signal the server to purge the binlog in order to reduce the storage size, but the storage size didn't change at all. Any ideas?
asked 2024-09-20T03:06:44.0966667+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(176, 80%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Avan Tan
0
Reputation points
commented 2024-09-24T15:40:28.98+00:00
Sai Raghunadh M
645
Reputation points Microsoft Vendor
3 answers
SQL OAUTH Connection Setup with Managed Identity using .net Framework Command Line application - Assistance Needed
Hi , We were able to retrieve the access token, but when I attempted to open the SQL connection, I encountered the following error: Microsoft.Data.SqlClient.SqlException: **'Login failed for user '
asked 2024-09-12T11:35:24.75+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(48, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Adigopula, Vijaya (CORP Admin Account)
0
Reputation points
commented 2024-09-23T18:18:06.2833333+00:00
Mahesh Kurva
265
Reputation points Microsoft Vendor
1 answer
Linkedserver connection to MySQL database with ODBC driver failed
Hi I am attempting to use a SQL Server 2014 linked server to connect to a MySQL 8 instance. My single openquery insert statement works fine, but when I try to run multiple insert statements to insert data to multiple tables, I receive a generic error…
asked 2024-09-17T05:53:47.2933333+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(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
binrip
0
Reputation points
commented 2024-09-23T18:12:05.8733333+00:00
Mahesh Kurva
265
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Cannot change the mysql user privilages
I am using Azure Database for MySQL flexible servers to manage my database. When I run the command below, I receive the result "Access Denied." I don't know how to access the admin account on Azure, but I can access the Azure portal. I have…
asked 2024-09-23T10:57:31.8666667+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, 35%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Buddika Abeykoon
20
Reputation points
accepted 2024-09-23T13:14:44.7833333+00:00
Buddika Abeykoon
20
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,326
Reputation points