Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
291 questions
1 answer
One of the answers was accepted by the question author.
Error connecting Oracle with c#
Hi everyone. I have an issue trying to connect Oracle with C#, I hope you can helpme. I’m using Oracle SQL Developer and make the connection successfully: Everything Works fine: But then, when I’m trying to connect to that database…
Azure Database Migration service
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,641 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,665 questions
asked 2021-10-19T12:51:15.877+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(156.8, 59%, 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)
programinca
21
Reputation points
accepted 2021-10-20T11:41:30.52+00:00
programinca
21
Reputation points
2 answers
DMA and DMS From On-premise SQL Server to Azure SQL managed instance
1.I can not use Migration part through DMA from SQL server to Azure managed Instance? Getting the message I can only use DMS for that(attaching the screenshot of the message). Somewhere in Microsoft Learn I read that we can use DMA for migration from SQL…
asked 2021-10-11T10:19:15.003+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-19T04:08:34.353+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, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YufeiShao-msft
7,081
Reputation points
1 answer
Connection Error with Azure DMS
I'm getting the error while connecting the DMS with my source SQL server. And, I'm using the free subscription. Attaching the screenshot of the error.
asked 2021-10-11T10:12:21.327+00:00
Nilesh Patel
111
Reputation points
commented 2021-10-14T22:40:38.213+00:00
Oury Ba-MSFT
18,021
Reputation points Microsoft Employee
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
Nilesh Patel
111
Reputation points
commented 2021-10-08T01:22:11.83+00:00
CathyJi-MSFT
21,126
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,791
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
18,021
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
18,021
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