Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
287 questions
1 answer
Azure Database Migration Services (LRS), target node restart
Hopefully a quick one, We're using Azure DMS to migrate from 1 SQL server to another - both are SQL Server on Virtual Machines. LRS is setup and running using Azure Blob storage - Full backups nightly, 5 minute Tlog backups on the source server. We have…
asked 2024-02-07T11:56:06.9933333+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, 94%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Carl Anderton
0
Reputation points
answered 2024-02-14T17:25:04.56+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
Not able to create Azure Database Migration Project
I need to create Azure Data Migration Project for one of my assignments, But I'm not able to do it from the Portal. No option for Creating a project is present. Previously I used to create it through Database Migration Services, But I'm not able to do…
asked 2024-02-08T10:30:52.6366667+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, 30%, 26%)' 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)
Apoorv Jain
0
Reputation points
answered 2024-02-08T12:35:21.0266667+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
14,276
Reputation points Microsoft Employee
1 answer
Azure SQL DB Sync with other databases is greyed out
I got same question, I was trying to transfer data from dynamic crm to On-Premises local sql server db, I put this azure database as middleware, first transfer data from crm to azure database, then try to using Azure database sync group to sync Data to…
asked 2024-01-16T16:50:02.4033333+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(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monique Ma
0
Reputation points
commented 2024-02-08T00:22:49.7333333+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
End to End Migration of On-Premises to Azure
Need real time case study with End to End Microservices design, development and deployment in .NET Technology
asked 2024-02-03T11:29:41.3933333+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(313.6, 65%, 40%)' 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)
rahul kulkarni
20
Reputation points
edited the question 2024-02-05T15:55:12.8466667+00:00
SadiqhAhmed-MSFT
40,291
Reputation points Microsoft Employee
2 answers
Online Oracle to azure PostgreSQL migration
Hi, We are planning to migrate 2TB Oracle database from on prem to Azure PostgreSQL. For schema conversion and migration we are planning to do with Ora2PG or Ispirer. Where we will convert schema and objects under them using one of these tools and…
Azure Database Migration service
Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
287 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,057 questions
asked 2024-02-05T09:48:15.0366667+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, 80%, 16%)' 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)
Siddharth Pawar
0
Reputation points
answered 2024-02-05T10:00:06.6066667+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
3 answers
Offline Migration to postgreSQL flexible server failes with extension creation error
Migrating my PostgreSQL Single Server to Flexible Server does not work. The error message is as follows: One or more errors occurred while migrating 'xxx' : EX001: Extension creation failed for the following extensions: hypopg, pg_buffercache,…
asked 2024-01-27T09:39:10.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(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWR%3C/text%3E%3C/svg%3E)
Wolfgang Roese
0
Reputation points
commented 2024-02-01T17:58:19.88+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL Databases that hold the data used and consumed by ADF pipelines
Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL databases that hold the data used and consumed by ADF pipelines. Can we migrate and move pipelines created in Azure Data…
asked 2024-01-24T18:29:07.2966667+00:00
Vaibhav Patil
140
Reputation points
accepted 2024-01-27T14:58:26.9+00:00
Vaibhav Patil
140
Reputation points
0 answers
Data Migration between two sql server using the Data Migration Assistant Tool
UseCase- I am performing Data migration between the two sql server using the Data Migration Assistant tool. i.e I am migrating the Data from sql server1 to sql server 2 Case works Fine- Data Migration using the DMA tool works fine when performing the…
asked 2024-01-16T12:51:42.0766667+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, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rahul
251
Reputation points
commented 2024-01-24T15:59:57.57+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Migração Azure for Postgres Flexivel
Boa noite, estou com um projeto para migrar os dados do meu PaaS Postgres Flexível com ip publico para uma nova instância idêntica do PaaS Postgres Flexível com Ip Privado, seria possível realizar essa demanda através do Azure Database Migration Service?…
asked 2024-01-18T00:31:56.5266667+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, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João
0
Reputation points
answered 2024-01-19T14:48:43.4633333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
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
ShaktiSingh-MSFT
14,276
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
17,631
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
60
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
29,007
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
29,007
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
20
Reputation points
commented 2024-01-02T14:02:08.5066667+00:00
Mikko Uusitalo
20
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
14,276
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
14,276
Reputation points Microsoft Employee