Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
279 questions
2 answers
Migrate On prem to Azure Sql Managed instance
I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…
Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
951 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 questions
asked 2024-04-23T17:46:35.1533333+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(108.80000000000001, 74%, 20%)' 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)
Shreedevi Sendarapatti Ramamoorthy
0
Reputation points
commented 2024-04-25T02:51:35.9433333+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
2 answers
Migration of On-Prem SQL Servers to Azure
Hello, I have 2 On-prem SQL Servers (One is primary server and other is Secondary server). SQL version is 2016 and edition is Enterprise. I have configured always-on for 10 big databases under multiple AAGs. Now I want to migrate my both On-Prem SQL…
asked 2024-04-16T09:02:02+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, 9%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Parth Mehta
0
Reputation points
commented 2024-04-18T05:04:45.1766667+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,271
Reputation points Microsoft Employee
3 answers
Free tier database only lasts half the month
The database is very simple, barely has any data or any calls being sent to it. Seems like a near empty unused database should not even last less than half a month on a free plan. Am I doing something wrong? It seems there is some sort of 'health event…
asked 2024-03-13T17:49:46.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(60.8, 77%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zach
5
Reputation points
answered 2024-04-13T08:03:39.28+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(195.2, 32%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
bemiyay881@vcrnn.com
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure DMS - point applications at target DB before cutover
When running an online migration with Azure Database Migration Service, are there any issues with pointing applications at the target database before running the cutover in DMS? In the cutover action in DMS it says to stop writes on the source DB to make…
![](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, 79%, 27%)' 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)
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.
asked 2024-03-08T22:14:06.02+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(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alexander Rauenzahn
20
Reputation points
accepted 2024-03-13T12:04:35.71+00:00
Alexander Rauenzahn
20
Reputation points
1 answer
Cloning an Azure Cosmos DB collection with Gremlin API
What is the best way to clone data from one Azure Cosmos DB collection to another using the Gremlin API? I'm considering using the Azure Data Migration tool, but I'm not sure if it will work in this case. Any suggestions would be appreciated.
asked 2024-03-05T19:55:54.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(25.6, 57.99999999999999%, 12%)' 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)
Surya
0
Reputation points
commented 2024-03-12T19:38:50.6066667+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Error during online migration of Postgres single server (v10.23) to flexible server (v16)
I attempted to perform an online migration on one database from a Postgres single server (v10.23) to a flexible server (v16), but encountered an error while reading the WAL logs. The error message states that "pgcopydb failed with unknown…
asked 2024-03-03T15:54:17.3433333+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(262.40000000000003, 78%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ronny Carlansson
20
Reputation points
accepted 2024-03-06T19:40:18.4233333+00:00
Ronny Carlansson
20
Reputation points
5 answers
Importing csv into Azure Data Studio taking forever
I tried to upload csv file into azure data studio using import flat file wizard extension. However, it has been loading forever. Could you suggest what I should do?
asked 2022-11-07T13:46:46.407+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(214.4, 26%, 30%)' 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)
Sophorn Thun
11
Reputation points
commented 2024-03-05T17:18:10.74+00:00
Erin Stellato
476
Reputation points Microsoft Employee
1 answer
MongoDB Atlas for Azure
I am trying to subscribe to Mongo’s private plan in CSP subscription. Can anyone please assist if this purchase is available for CSP subscriptions?
asked 2024-03-01T07:11:51.18+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nagrath, Richa
21
Reputation points
commented 2024-03-04T16:56:38.9933333+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
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
16,081
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
ShaktiSingh-MSFT
13,271
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
16,081
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
37,686
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.
279 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.
951 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
13,271
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
16,081
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
![](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, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vaibhav Patil
20
Reputation points
accepted 2024-01-27T14:58:26.9+00:00
Vaibhav Patil
20
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
27,102
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
27,102
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
13,271
Reputation points Microsoft Employee