Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
288 questions
1 answer
Replication methods in Azure for Sql Satabases
I want to replicate data from cloud to cloud databases. What are the various methods that i can try to complete the demand?
asked 2021-01-29T06:48:46.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(284.8, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shubhanshu Dubey
21
Reputation points
commented 2021-02-01T22:51:26.073+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 SQL Server and Azure MySQL migration options to AWS :(
Dare I say it in this forum....we are moving a client's managed Azure SQL Server database (3.8TB) and multiple smaller Azure MySQL databases to AWS RDS SQL Server and Aurora MySQL respectively with minimal downtime permitted (max 2 hours). DMS is…
asked 2021-01-22T10:15:11.943+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
answered 2021-01-26T00:59:26.53+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Need help on parameterization of Integration Runtime and Azure Key vault Secrets on link service in Azure Data Factory pipeline
Hi, I have to migrate 90 clients database from Azure Managed Instances databases to Azure VM Data Servers. For the above requirement, I have created the below resources * 90 Azure Data Factory Pipelines * 90 self-hosted integration runtime as each…
asked 2020-12-29T17:41:43.283+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(16, 57.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH0%3C/text%3E%3C/svg%3E)
HemantSudehely-0557
266
Reputation points
commented 2021-01-08T10:42:37.77+00:00
Nandan Hegde
30,871
Reputation points MVP
2 answers
Using Azure Dms is it possible to migarte sql databse of 5Tb to azure Vm with ? What are limitations and known issues while migrating huge dbs to azure vm with azure DMS tool?
We are planning to migrate 5 Tb of sql db to azure Vm with help of azure DMS ? does dms support sql db with huge sizes like this? Azure Dms does supports only offline migration for azure vm . what is avg time taken by for migrating sql db with…
asked 2020-12-18T09:51:35.783+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(188.79999999999998, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vishnuvardhan Settipally
1
Reputation point
commented 2020-12-30T06:09:38.497+00:00
Vishnuvardhan Settipally
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Mainframe to Azure cloud Migration-Best practices and considerations
We are planning to migrate our existing Mainframe code by rewriting in Python or JAVA.We need to migrate our Mainframe DB2 tables and files to Azure cloud for our IT modernization .After evaluation of migration process and cost comparison of Mainframe…
asked 2020-12-17T18:58:31.853+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(9.6, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
vignesh sivashanmugam
21
Reputation points
accepted 2020-12-23T05:08:00.403+00:00
vignesh sivashanmugam
21
Reputation points
5 answers
Can we install MSSQL(2019) on linux with different user and group?
Hello Team, Can you please let me know, if we want change username and group name for MSSQL(2019) installation on Linux REHL8.X. How to do it. Can you let us know can we change this before or after MSSQL installation. If yes then please provide us…
asked 2020-11-27T14:13:36.867+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(176, 2%, 27%)' 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)
Mj Taseen
1
Reputation point
commented 2020-12-03T01:39:22+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
2 answers
One of the answers was accepted by the question author.
How to optimize Azure Data FactoryPipeline?
Hi All, Need help on the below requirement... I have to perform ADF migration from 90(source and target Azure MI databases) For Example Source on-prem servers(data server1, data server2, data server3,...data server90) to Target Azure MI Servers(Azure MI…
asked 2020-11-30T19:07:13.233+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
commented 2020-12-01T15:18:15.527+00:00
Anonymous
2 answers
One of the answers was accepted by the question author.
compression FILESTREAM SQL Server Express 2014
Supprimer l'alerte|Modifier|Type de modification Question Vous ne pouvez pas voter pour votre propre billet. 0 Hello I'm Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server Express 2014, the problem is when I store the image…
![](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, 56.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
2 answers
Azure Searching On File Attachments
I need to convert some Oracle databases to MSSQL AZURE. We seem to have most things working except the ability to search on file attachments Oracle lets us index a column in a table that uses a filepath link. I got excited in MSSQL when a column in…
asked 2020-11-12T22:59:38.31+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(192, 76%, 28%)' 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)
OZDBA
1
Reputation point
commented 2020-11-13T09:20:41.893+00:00
Cris Zhan-MSFT
6,611
Reputation points
2 answers
Failed deploy data base from ssms to azure sql
Hi, while trying to upload from an on premise sql server manager studio to azure sql database I encountered an error and the operation failed. I am using the latest ssms (v.18), in addition in my azure database I have a maximum storage size of 500…
asked 2020-10-12T06:16:10.293+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, 7.000000000000001%, 28%)' 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)
Amir Ariely
1
Reputation point
commented 2020-10-13T01:43:53.92+00:00
m
4,271
Reputation points
10 answers
One of the answers was accepted by the question author.
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to?
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to? A2SS0030 Identifier name might cause problems A2SS0030: Foreign key '{5A15D9A6-64CE-44B3-AD29-21EAF86F0328}' has a name that might cause…
asked 2020-09-11T09:48:48.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(89.60000000000001, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bob Alston
121
Reputation points
answered 2020-10-08T21:48:23.697+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
1 answer
VS 2019 instead 0f 2107?
I need to open my Azure Database in VS 2019 instead of 2017. How can I get this done without uninstalling VS 2017?
asked 2020-09-22T00:42:46.263+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, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Amos Matthew
26
Reputation points
commented 2020-10-03T01:15:06.077+00:00
Amos Matthew
26
Reputation points
1 answer
Migrate managed databases to Azure SQL
We have multiple instances of SQL Managed Instances running and are looking to move our databases to Azure SQL with an elastic pool. I see documentation on migrating from on premise to Azure SQL but what is the best method to bring over databases from an…
asked 2020-09-16T16:56:35.76+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(38.4, 21%, 13%)' 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)
Patrick
1
Reputation point
commented 2020-09-23T05:57:11.51+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Fail upload DMA to azure sql
When i tried to connect to the server(using DMA) i got this error There are validation errors in the source serve. "Invalid source server details were specified for the migration. Server 'XXXX.database.windows.net' has an unsupported database…
asked 2020-09-17T05:55:55.09+00:00
Amir Ariely
1
Reputation point
answered 2020-09-23T05:51:34.833+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
SQL Server - Restore From a [large] Full Backup file
Wanted to do a regular backup from a repository file server. My Logic says ... you should first copy the file to a local mounted volume on the server and then run the restore. However, after testing a few times, we found out that if you do the…
asked 2020-08-19T17:10:13.903+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, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
travisGatesMcGee@hotmail.com
21
Reputation points
answered 2020-08-29T02:54:27.167+00:00
travisGatesMcGee@hotmail.com
21
Reputation points
1 answer
One of the answers was accepted by the question author.
how to migrate data from on-premise sql server to azure postgresql
we have tried to migrate data from on-premise SQL to azure PostgreSQL by using database migration service but we are not able to select target as PostgreSQL when source is SQL server.
asked 2020-08-19T07:22:05.727+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, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aditya MALKA
21
Reputation points
accepted 2020-08-20T17:41:07.19+00:00
Aditya MALKA
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Inconsistant database state between Azure Portal and SSMS
While learning how to use the Azure Database Migration service, I had a migration from on prem to an SQL Managed Instance get stuck. I cancelled and deleted the migration project, but the two databases I was migrating now seem to be stuck in a bad…
asked 2020-08-07T19:26:40.773+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, 20%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Andy Wybenga
21
Reputation points
accepted 2020-08-10T13:02:22.46+00:00
Andy Wybenga
21
Reputation points
1 answer
Does transactional replication work on Azure managed instance with Publisher being on-prem SQL server 2008 r2 ?
I have SQL Sever 2008 R2 on-prem. Scenario 1: I am trying to create transactional replication from on prem SQL server 2008 R2 (being publisher) to Azure SQL managed instance 2019 (as being subscriber) Scenario 2: I am trying to create…
asked 2020-07-30T06:05:22.737+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 2020-08-03T04:20:27.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(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
1 answer
Replication from on premises to SQL Managed Instance
Hi, Will transaction replication work from On premises to SQL Managed Instance. If yes, what are the terms and conditions and What ports should be open from both sides. Thanks, Saikumar Gaddam
asked 2020-07-30T18:09:28.737+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(70.4, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Saikumar Goud Gaddam
1
Reputation point
commented 2020-08-03T04:18:36.813+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
0 answers
Set Database Extension fails with GatewayTimeout after restoring DB from .bacpac
I am attempting to import a database via a .bacpac file which I have stored in blob storage. I have created an Azure SQL serve, and followed the import steps described in the video attached:…
asked 2020-07-14T06:28:50.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(195.2, 8%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael Fanning
1
Reputation point
commented 2020-07-28T05:40:19.787+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