Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
280 questions
1 answer
One of the answers was accepted by the question author.
How to create Newer Version of Azure Database Migration Service using PowerShell
The retirement of Azure Database Migration Service (classic) for SQL Server scenarios requires migrating to the latest Azure Database Migration Service version. However, the New-AzDataMigrationService command still creates the classic version. What…
![](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, 22%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
2 answers
I have few confusion for SQL migration from OnPrem to Azure in between DMA/DMS/ Data studio & Azure Migrate
I have the below queries If Azure Migrate Readiness Report Recommend Onprem DB into Azure SQL Managed Instance & at onprem location, DMA was set up. In that case, is it required to set up Data Studio also at the on-prem location, as DMA does not…
asked 2024-01-14T08:24:18.5566667+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(128, 8%, 22%)' 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)
Anonymous
answered 2024-01-16T09:41:44.89+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
13,441
Reputation points Microsoft Employee
0 answers
Advise for Lost of Visibility on Historical Data After PAC Entitlement Transfer
Hi We are Indirect Providers and are descontinuing one partner center and transfering Entitlements between Azure Plans in the process. We are finding the challenge that historical data is no longer visible after event. Is there other ways to populate…
asked 2024-01-12T16:36:33.6033333+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(163.2, 3%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lutterbach, Mateus
0
Reputation points
commented 2024-01-15T16:58:54.4066667+00:00
Lutterbach, Mateus
0
Reputation points
0 answers
Azure DMS doing a Full Load each time for a FAILED activity on PostgreSQL
Looking to migrate a 1 TB PostgreSQL database from on-prem ubuntu VM to Azure PostgreSQL Flexible Server using Azure DMS. Appears Azure DMS is doing a full load each time the migration activity fails (like when the source database is restarted, network…
asked 2024-01-12T17:28:57.5533333+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(249.60000000000002, 7.000000000000001%, 34%)' 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)
K Sateesh Kumar Reddy
0
Reputation points
commented 2024-01-13T18:12:42.0733333+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Need to copy CDC changes from MULTIPLE Azure SQL DB source TABLES and SCHEMAS to an Azure Managed SQL Instance using ADF
I'm relatively new to ADF and finding it difficult to configure CDC replication between multiple source Azure SQL Database tables to associated target Azure SQL Managed Instance db tables. I have found numerous excellent blogs and demo's on SINGLE…
asked 2022-02-21T07:38:49.987+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(115.19999999999999, 84%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Ozi
31
Reputation points
commented 2024-01-12T01:25:29.58+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(166.4, 83%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashwani SRIVASTAVA
40
Reputation points
2 answers
One of the answers was accepted by the question author.
migration of Azure content to account under changed company email
My company changed email address and thus I got a new Azure account. I want to transfee all storage account and blob details from my old account to my new. Are there tools for export/import or do I have to do all steps manually?
asked 2024-01-03T05:44:11.72+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, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Coffeng, René
20
Reputation points
accepted 2024-01-08T13:27:30.9833333+00:00
Coffeng, René
20
Reputation points
1 answer
How to quickly put very large CSV data into a DB?
I have 22 files that are between 35GB and 50GB each, totaling 880GB of CSV files. There are about 4.6 billion rows of data. I am using "Azure Database for MySQL" and would like to import all of these CSV files into it. I tested the import by…
asked 2023-12-30T06:59:00.9833333+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, 45%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Ryan Lee
0
Reputation points
commented 2024-01-03T17:07:19.6466667+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
How to move a database between tenants in Microsoft Azure?
Hello, I would like to transfer a database from one Azure tenant (x) to another (y). Is there a way to do this and what steps do I need to take? Thank you for your assistance.
asked 2023-12-13T11:43:36.7733333+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(6.4, 46%, 10%)' 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)
Sutheswaran, Suwhathi
70
Reputation points
edited the question 2024-01-03T16:37:26.3866667+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
Issue with migration process from Azure PostgreSQL single server to Azure PostgreSQL Flexible server
I am trying to start migrating Azure PostgreSQL single server to Flexible server. After choosing target and pressing Go to migration wizard, I am getting this black screen. This has worked last week but now not. Are you experiencing some issues here?
asked 2023-12-19T14:23:11.36+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(60.8, 47%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Mikko Uusitalo
15
Reputation points
commented 2024-01-02T14:02:08.5066667+00:00
Mikko Uusitalo
15
Reputation points
1 answer
My migration extension is not working in my Data Studio.
I wanna migrate from aws rds to azure sql managed instance. I have connected my databases in data studio and installed the migration extension too but its not showing up in the databases manage section. How should i start the migration?
asked 2023-12-18T06:41:23.8766667+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(128, 18%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nischay
0
Reputation points
commented 2023-12-20T13:38:50.1433333+00:00
ShaktiSingh-MSFT
13,441
Reputation points Microsoft Employee
1 answer
not listing location/region details under azure Database migration service (DMS)
please help for the below issue am trying to migrate mysql single server to mysql flex using azure Database migration service (DMS), created a project to do online migration, after selecting the subscription under location region are not listing.…
asked 2023-12-15T20:44:03.86+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(19.2, 85%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sridhar
0
Reputation points
commented 2023-12-19T05:06:29.87+00:00
ShaktiSingh-MSFT
13,441
Reputation points Microsoft Employee
2 answers
Reliable way for AWS Aurora PostgreSQL to Azure PostgreSQL migration
Hello community members, Looking for an approach for migrating live AWS Aurora PostgreSQL database in Azure. As Azure DMS doesn't support this as a source but given Aurora is built on top of PostgreSQL, what are possible ways considering need is to…
asked 2023-09-28T04:38:57.9233333+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(185.6, 60%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rohit Agarwal
5
Reputation points
answered 2023-12-13T05:22:40.53+00:00
Vishwesh
0
Reputation points
1 answer
Not being able to connect to my aws rds database from data migration assistant
I am trying to migrate data from aws rds to azure sql managed instance but i having error while connecting to my target server (aws rds). I am using <endpoint>,<port> notation. This is the error i am facing: Connection to the server…
asked 2023-12-12T12:10:14.9933333+00:00
Nischay
0
Reputation points
edited an answer 2023-12-12T17:04:42.0133333+00:00
Alberto Morillo
32,891
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Retirement notice: Database Migration Service (classic) - SQL scenarios retirement by 15 March 2026
Azure Database Migration Service (classic) - SQL Server scenarios will not be supported after 15 March 2026. Beginning 01 August 2023, you will no longer be able to create new Database Migration Service (classic) resource for SQL Server scenarios.…
asked 2023-03-17T19:30:29.1833333+00:00
bharathn-msft
5,086
Reputation points Microsoft Employee
commented 2023-12-07T08:49:56.58+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(57.599999999999994, 48%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Abhishek Kumar
0
Reputation points Microsoft Employee
1 answer
How to Migrate Oracle from One Azure Subscription to Another Azure Subscription
How to Migrate Oracle from One Azure Subscription to Another Azure Subscription How to Migrate SQL from One Azure Subscription to Another Azure Subscription How to Migrate MYSQL from One Azure Subscription to Another Azure Subscription How to Migrate…
asked 2023-11-29T22:12:49.27+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(124.80000000000001, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Sukhen Tiwari
0
Reputation points
commented 2023-12-04T06:15:09.0766667+00:00
ShaktiSingh-MSFT
13,441
Reputation points Microsoft Employee
1 answer
Moving a subset of data from one Cosmos db container to other
Hi all, I am looking for migrating a subset of data from one of the Containers to another in same Azure account. I have 2 containers: AccountDetails and Users. Both containers have their respective data rows. As per the requirement, I need to have few…
asked 2023-11-15T19:33:29.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(115.19999999999999, 73%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rajan Mishra
0
Reputation points
edited a comment 2023-11-15T22:53:34.3466667+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
Azure database for PostgreSQL Single Server migrate of large database of 3 TB size
I would like to migrate large database upto 3TB to new flexible server, Problem 1: my existing database collocation "Thai" not support show output languages miss math mean "UFO Charecter cannot read" Problem 2: During migration…
asked 2023-11-15T03:45:53.78+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, 84%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Wutiklai Chapanya
0
Reputation points
answered 2023-11-15T08:46:46.9533333+00:00
ShaktiSingh-MSFT
13,441
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to migrate Oracle database RMAN backup from one Azure subscription to another.
Hi, We have one Oracle EBS database running in on Azure's Production subscription. We want to build a standby database in Azure's Dev subscription. How can we achieve this. Regards, Narottam
asked 2023-09-29T12:20:27.0233333+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(185.6, 41%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Patankar, Narottam
20
Reputation points
accepted 2023-11-10T09:51:00.55+00:00
Patankar, Narottam
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
asked 2023-11-02T16:25:02.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(9.6, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Albeiro Jimenez Lopez
20
Reputation points
commented 2023-11-03T18:16:45.9833333+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
PostgreSQL single server to flexible server migration error - permission denied for admin user
When I am doing migration of 3 databses(schemas), between single server and flexible server postgresql I am getting error shown below Data migration could not be started for one or more of the DBSets. Error details: PGv2RestoreError: PG Restore…
asked 2022-11-04T16:03:06.997+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(160, 83%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nowakowski Krzysztof
21
Reputation points
answered 2023-11-03T13:45:31.37+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(284.8, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
devopsfj
156
Reputation points