Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
288 questions
1 answer
Connection with DMA
While I was connecting my My SQL server 2019 with the DMA tool I'm getting the error. PFB the error message : Connection to the server failed. VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does…
asked 2021-10-05T11:16:52.967+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, 47%, 22%)' 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)
Nilesh Patel
111
Reputation points
commented 2021-10-08T01:22:11.83+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
Which azure service should I use.
So I have a pretty big on-premise ssms database and I want to use some data from it in azure Machine Learning. I need to use just a small amount of data from my db, from certain tables. Also this data updates from time to time. I want you to help…
asked 2021-10-06T08:56:46.17+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, 86%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cherkasov Dmitriy
1
Reputation point
commented 2021-10-06T14:34:22.96+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
3 answers
One of the answers was accepted by the question author.
Questions Related to Data Migration Assistant
I am get to the DMA tool, I need to ask some basic questions related to this tool : Where DMA can break or fails ? Data transfer rate of DMA tool ? If tables and data are complex, does it affect the migration? Will DMA handle everything and …
asked 2021-10-01T08:16:28.197+00:00
Nilesh Patel
111
Reputation points
answered 2021-10-04T23:36:37.797+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(12.8, 84%, 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)
siyao
86
Reputation points Microsoft Employee
1 answer
MySQL Move or Replicate to Germany
We need to move for financial reasons our Azure Database for MySQL from North Europe (Ireland) to Germany. We have seen that the specific resource type is available at Datacenters in Germany. As far as I can see it is not possible to move the…
asked 2021-09-29T12:51:40.07+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(67.2, 47%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mike Sarafidis
1
Reputation point
commented 2021-10-01T05:13:51.11+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
One of the answers was accepted by the question author.
Mysql Database master-slave Replication
Hi, I have a DB server on premise or aws rds and i want to create a read replica(Slave Server) on azure mysql Database. Can i perform this task? If yes, how?
asked 2021-09-23T07:39:24.583+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, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Shubham Choudhary
21
Reputation points
accepted 2021-09-23T11:28:43.95+00:00
Shubham Choudhary
21
Reputation points
1 answer
Migration from one Azure environment to another Azure environment
Hello how are you? I'm facing a problem in my company and I'd like to know if you can help me. How would I migrate an azure environment from a customer's environment to a new Azure environment in my company? have any indication of studies, course,…
asked 2021-09-21T02:39:37.143+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(92.8, 54%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Bruno dos Santos
1
Reputation point
answered 2021-09-21T03:21:46.237+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, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Devaraj G
2,091
Reputation points
1 answer
SQL Server 2016 SP2 Standard on Windows Server 2016 - Gen1
I am not able Create the VM on SQL Server 2016 SP2 Standard on Windows Server 2016 - Gen1 , not showing ant error but VM creation running continue..... plz help
asked 2021-09-08T13:17:11.307+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, 9%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mahendra Singh Kashyap
1
Reputation point
commented 2021-09-13T20:55:00.41+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, 44%, 29%)' 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
23,781
Reputation points Microsoft Employee
0 answers
Migration tools
Hey microsoft azure, Good Morning , i'm Desmond i was wondering for the current application that i am using am i able to migrate to azure. Currently i am using NAV 2009 R2 if i want to upgrade to azure cloud what application should i have to assist…
asked 2021-08-26T02:31:58.367+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, 72%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
desmond lim
1
Reputation point
commented 2021-09-13T17:47:54.957+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
0 answers
offline DMS migration from Azure SQL VM to Azure SQL DB
I am migrating my databases from Azure SQL VM to Azure SQL DB using offline migration but while migrating I am getting a error i.e " Microsoft.Azure.Management.DataMigration.Models.ODataError" I am using powershell script to migrate the…
asked 2021-09-03T05:55:15.643+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(28.799999999999997, 25%, 12%)' 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
21
Reputation points
commented 2021-09-06T08:35:31.723+00:00
Shubhi Jain
21
Reputation points
1 answer
DataFactory Alter Row into Sink
Hello! I am deleting some blank rows from my data, I am using the 'Alter Row' function to after which I am running a isNull(COLUMNNAME) to get rid of the data. It is appearing fine in the Alter Row box during the data preview, however after I try…
![](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, 95%, 37%)' 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)
1 answer
Restore TDS enabled Managed instance database to on premise sql server
I have a Azure Managed instance database with TDE enabled (customer managed keys) , i need to take copy_only .bak backup for this MI database to azure blob storage using SAS URL(I achieved this by creating certificate and running Tsql query) . Now my …
asked 2021-08-26T21:00:27.133+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, 15%, 30%)' 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)
SethuRam
66
Reputation points
answered 2021-08-31T09:55:18.913+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Transaction replication issue from on-premises to azure
We have transactional replication from on-premises to Azure managed instance but whenver pacting is done , replication will fail and we need to reintalize it , please any idea that can fix this issue
asked 2021-08-10T18:39:51.827+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, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Solomon Kibret
1
Reputation point
commented 2021-08-19T23:18:03.05+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
How to migrate JD Edwards from on-prem to Azure
Scenario 1: I have JD Edwards Application with Oracle database running on-premise. I am planning to move it t Azure and use SQL Server as database instead of Oracle. I want my JD application to be on cloud as it is, the only thing that will be…
asked 2020-08-12T18:30:17.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(118.4, 85%, 21%)' 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)
Swapnil Solanki
1
Reputation point
commented 2021-08-19T16:15:27.543+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, 68%, 11%)' 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)
Dale9EDGE
1
Reputation point
1 answer
One of the answers was accepted by the question author.
challenges migrating on-premise data solutions to Microsoft Azure
Hi All, Sorry it sounds a generic question but when we are migrating monolith of on- prem applications nearly 1000 TB of data with has upstream transactional databases and streaming data. What are key challenges we must kept in mind from architecture…
asked 2021-08-14T11:36:54.66+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, 12%, 33%)' 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)
Samy Abdul
3,366
Reputation points
accepted 2021-08-18T12:54:52.513+00:00
Samy Abdul
3,366
Reputation points
1 answer
One of the answers was accepted by the question author.
Does Azure Database Migration Service (DMS) support SMB1 for online migration?
I am planning to migrate obsolete on-premise SQL Server database to Azure SQL Managed Instance using Azure DMS online migration and am preparing the prerequisites according to this documentation. I see that DMS needs to fetch the database backup…
![](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, 5%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Minimum permission required for SQL Server Migration Assistant for DB2 (DB2ToSQL)
Hi, I am trying to use SQL Server Migration Assistant for DB2 (DB2ToSQL) for my migration project. As part of the project requirements, I need to request for a db2 service account for the migration project. However, the SSMA documentation does not…
asked 2021-07-14T03:54:42.023+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, 41%, 31%)' 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)
saurabh
356
Reputation points
commented 2021-07-26T19:14:40.963+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, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov
491
Reputation points
5 answers
Is there a faster way (than bacpac export/import) to move SQL on-prem databases to Azure SQL?
We have about 2 Terrabytes of data in SQL Server 2014 on-prem servers that we need to move into Azure SQL. The data is distributed among about 50 databases with no database larger than 200GB. The best method we have come up with so far which ends with…
asked 2021-07-20T21:41:00.783+00:00
Kazoo60
16
Reputation points
commented 2021-07-23T09:17:39.817+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(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT
16,461
Reputation points
1 answer
I have been performing CDC task , after any insert/update operation, the CT table is not being reflected with any changes made
The CDC is enabled at database as well as table level. Still, no changes in the CT table.
asked 2021-07-01T14:55:03.707+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(217.60000000000002, 70%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
Ashutosh Ubale
1
Reputation point
commented 2021-07-15T21:29:13.43+00:00
Saurabh Sharma
23,781
Reputation points Microsoft Employee
4 answers
Linked server b/w two Azure SQL database using SQL jobs
I have one Azure SQL server on one account, same replica is created with other account (Azure SQL DB) also. I want to send SQL data from one account to other account frequently (Every 3 hours), but not sure how we can connect those two SQL databases.…
asked 2021-07-10T06:58:44.933+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(89.60000000000001, 47%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gyanendra Singh Rathore
1
Reputation point
commented 2021-07-14T07:25:11.047+00:00
Anurag Sharma
17,586
Reputation points
1 answer
Online migration from RDS for MSSQL to Azure sql
I need to online migration RDS for MSSQL to Azure SQL (not MI) in this year, Feb. it was supported and worked well because, I used it even it's not MI but now it's not working and i can't find way any more! please check it. …
asked 2021-06-22T04:48:00.113+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, 78%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Ian Kim
6
Reputation points
commented 2021-06-24T20:53:00.577+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee