Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
288 questions
1 answer
other options for online Migration using DMS
I have 200 database and I want to migrate it from on-premises to Azure SQL with continuous sync. what are the other option I can follow to get this sync as Online Migration From DMS is no longer supported. …
asked 2021-06-16T13:27:39.953+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, 64%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shubhi Jain
6
Reputation points
commented 2021-06-23T10:14:40.097+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(297.6, 97%, 38%)' 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)
Anurag Sharma
17,586
Reputation points
1 answer
on-promise Oracle to azure sql via SSMA too many errors
we using SSMA migrate oracle schema to Azure sql, but there has too many errors, any idea to fixes these error quickly
asked 2021-06-02T13:01:49.093+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(35.2, 20%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYH%3C/text%3E%3C/svg%3E)
Yang, Henry-D
1
Reputation point
commented 2021-06-07T15:35:58.347+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
PAAS Migration -Migration from Azure SQL Single Instance /Azure VM to Azure Managed Instance
Could you please give some overview on the migration approach for Migration from Azure SQL Single Instance to Azure Managed Instance. Could you please provide inputs on the following things: Backup /restore strategy used for the migration. Can we use…
asked 2021-05-17T06:23:13.167+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(147.20000000000002, 19%, 24%)' 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)
Ramya Lakshminath
21
Reputation points
commented 2021-05-19T05:58:33.107+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, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
0 answers
SQLServertoAzure migration : error while connecting to source in local computer
I am trying to migrate my Database in SQL server on my local computer to Azure Database. Under my Data Migration Service, when i create a "New Migration Project" and enter the details for the source SQL server(in my local computer), i get…
![](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(41.6, 49%, 14%)' 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)
1 answer
One of the answers was accepted by the question author.
On prem DB2 Migration to PostgreSQL in Azure
Hi, Does Azure migration service migrate DB2 instance in on prem to PostgreSQL in Azure. How long it will take to migrate Let say we have 1000 tables ? Or only we have an option of provisioning a VM and running DB2 instance (Rehost strategy) ? …
asked 2021-04-20T09:59:07.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(300.8, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
V R Venuu Maadhav
21
Reputation points
accepted 2021-04-20T12:40:18.983+00:00
V R Venuu Maadhav
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Database experimentation Assistant (DEA)- Replay trace facing issue.
We are measuring SQL server performance between Azure MI SQL server 2012 and 2019 using DEA. In DEA we have successfully save XEvent on blob storage. Now when we are trying to replay trace on Target A and when replaytrace is running we are getting…
asked 2020-06-26T12:04:39.557+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, 66%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nikunj Patel
186
Reputation points
accepted 2021-04-20T11:29:28.963+00:00
Nikunj Patel
186
Reputation points
2 answers
One of the answers was accepted by the question author.
Data Migration Assistant fails to export any records on all tables that contain any data
Data Migration Assistant V5.3 fails to export data on all tables that contain any records with the error "The pipeline to query metadata for table ... Specified argument was out of range... Parameter name: approxDataSizeKb" while trying to…
asked 2021-04-05T04:38:30.833+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, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Admin (Azure)
21
Reputation points
commented 2021-04-16T22:54:40.877+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
0 answers
Unable to access network file share from Azure DMS during migration
Hi team, Hello team, During migration from AWS IAAS to Azure Managed Instance, we are facing access authentication issue to the network share path from the DMS. We have provided the necessary privilege to the network path . Also, port 445 and 1433…
asked 2021-04-13T12:25:16.82+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(35.2, 45%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
ads.asaha
1
Reputation point
commented 2021-04-16T00:46:37.923+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, 93%, 37%)' 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)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Azure Dataplatform databrick need ip addressing change
Hi, I'm facing a requirement that i don't know yet how to address it. A dataplatform have been deploy in Azure here is some components : Databricks service, Data factory, NSG, Priv endpoint keyvault, Vnet, subnets. We need to migrate IP range…
asked 2021-04-09T11:38:52.203+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, 89%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
Nicolas Finetin
1
Reputation point
commented 2021-04-15T18:24:33.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(48, 36%, 14%)' 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)
SaiKishor-MSFT
17,216
Reputation points
1 answer
There are duplicate column names 'Id' in the structure. An item with the same key has already been added. Activity ID: 1ff3c2a6-fae1-4aa0-b728-8fde216082ac
We are looking to query data in SF using ADF and here is the error I am receiving: There is a duplicate column names 'Id' in the structure. An item with the same key has already been added. Activity ID: 1ff3c2a6-fae1-4aa0-b728-8fde216082ac Query : …
asked 2021-04-09T15:26:58.68+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(179.20000000000002, 68%, 27%)' 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)
Nik Kasala
1
Reputation point
commented 2021-04-14T14:39:28.287+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, 70%, 26%)' 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)
MartinJaffer-MSFT
26,051
Reputation points
1 answer
migration from mysql 5.7 to Mysql 8 managed
We have mysql 5.7 on azure ubuntu 14.04.6 servers we want to migrate to azure mysql 8 managed instances. I didn't see in azure an option to migrate to 8 but only to 5.7. is there a way if we migrate to 5.7 managed then to upgrade to 8 or migrate to 8…
asked 2021-04-05T09:04:40.897+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, 38%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
Yoni Yahav
21
Reputation points
commented 2021-04-06T13:36:58.813+00:00
Yoni Yahav
21
Reputation points
1 answer
Azure SQL Server firewall not allowing operation to connect even though option is set to yes in firewall settings
I am trying to import my local SQL server database into Azure & I have all the requirements (storage, bacpac file, etc). When I try to import the db, I am getting the error below. The Azure SQL Server firewall did not allow the operation to…
asked 2021-03-26T14:51:17.44+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, 16%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marco Pagan
6
Reputation points
answered 2021-03-30T01:29:11.357+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Azure data migration service failed at log backup
when migrating to SQL MI . I find the first full backup was able to upload to the blob storage . however in the next step. there is error . And in the sql server error log . I see what's happening here ? I have already give sql…
asked 2021-03-24T10:42:07.663+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(137.6, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2021-03-30T00:13:04.5+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
ANALYZE command in azure database for postgresql
Hi Team, Looking for some inputs on the below. We are in the process of moving our on premises postgres v10 to azure database for postgresql(v11) single server. Do we need to manually run ANALYZE on all tables on the PAAS platform (azure database for…
![](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(208, 87%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
1 answer
DMS - SQL server online migration, transaction log is not loaded
Hello everyone, we are using DMS to perform the online migration of a DB of approximately 300 GB. What happens In the shared folder there is a full backup and then the transaction logs are generated. What happens is that the DMS uploads only the…
asked 2021-03-06T01:24:19.1+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(265.6, 94%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Breno Padovan
21
Reputation points
commented 2021-03-10T15:39:12.903+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Migration Project won't connect to Azure Managed Instance Target server
I have a running SQL managed instance that is useable via my on-Prem SQL Studio. I can create and destroy databases via Portal and on-prem ssms I made sure ports, 1433, 443, 445, 9354 and 12000 were open. I can connect via SSMS with my azure…
asked 2021-03-08T17:57:19.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(147.20000000000002, 39%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Alex Hatcher
6
Reputation points
commented 2021-03-09T03:00:08.237+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Replicate Azure SQL to Azure SQL
I know that we can replicate between SQL databases in on-premise SQL. Can we replicate only a few tables from one Azure SQL DB(PaaS) to another Azure SQL DB (PaaS)
![](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(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Azure DMS Issue 'Failed input validation'
Hi All, We are trying to do test migration from an on-premises sql server (2017STD) to a Azure SQL Database. Steps Taken So far Installed DMA on a on-premises local machine, ran the schema migrate option for the local DB. Resolved the issues…
asked 2021-02-19T16:20:20.48+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, 71%, 15%)' 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)
Sliverlight
236
Reputation points
commented 2021-03-02T02:44:52.763+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Migrate data from Cassandra database to Azure Cosmos db(Cassandra API)
Around 100gb(might be more) need to be migrated to Cosmos db(Cassandra API). Checked the document sstalbleloader is not supported by Comos DB. can someone please suggest the possible ways to migrate data from Cassandra to Cosmso DB?
asked 2021-02-19T15:07:59.16+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(147.20000000000002, 61%, 24%)' 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)
Sharma, Pushkal-XT
1
Reputation point
answered 2021-02-21T17:29:45.29+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
What oracle native features not supported in postgresql
What oracle native features not supported in postgresql that need to considered for pre-assessing Oracle databases for conversion to Azure Postgresql.
asked 2021-02-07T13:59:18.15+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, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sabir Laskar
21
Reputation points
commented 2021-02-17T05:46:55.857+00:00
Anurag Sharma
17,586
Reputation points