Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
291 questions
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
1 answer
Cosmos DB Migration Tool - SQL Database to Cosmos DB
Hi there, I have data saved in SQL Database, which I'm migrating. I used to save Lat and Lon into a separate column, but for the new implementation, I'm saving lat and lon as GeoJSON point. While migration, I want to save Lat and Lon as GeoJSON on…
asked 2020-07-04T04:50:15.533+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(275.2, 93%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETE%3C/text%3E%3C/svg%3E)
Tahmid Eshayat
286
Reputation points
commented 2020-07-15T20:08:05.06+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
MongoDB and MariaDB migration to Azure Cloud
I have got MongoDB and MariaDB on premise databases. I am planning to move to Azure cloud. Do Azure provide an option to host MongoDB and MariaDB on cloud. Before migration i would like to do an assessment of an existing MongoDB and MariaDB, does…
asked 2020-07-09T08:51:55.48+00:00
Swapnil Solanki
1
Reputation point
answered 2020-07-09T14:28:35.957+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, 98%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Malleswara Reddy, G
1,631
Reputation points
3 answers
Migrate to SQL Paas
Hello I have SQL 2016 always on and it is hosting the below -One instance for Database -One instance for SQL reporting services -4 Databases what is the best option to migrate all these database to Azure SQL paas
asked 2020-06-23T08:35:03.09+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, 75%, 12%)' 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)
yasser Mohamed AbdelMoneim
291
Reputation points
commented 2020-06-28T22:09:05.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(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
One of the answers was accepted by the question author.
how to replicate ongoing changes of on prem database to data lake?
Like AWS DMS handles ongoing replication and update bucket with respective files, what is available in azure to manage ongoing changes occurring at on-prem sql database? Initially it requires to do a full load in my data lake storage which can be…
asked 2020-06-19T17:52:50.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(73.60000000000001, 42%, 17%)' 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)
Seuli Das Majumder
101
Reputation points
accepted 2020-06-25T13:31:24.097+00:00
Seuli Das Majumder
101
Reputation points
1 answer
List of required allowed services, allowed resource types and allowed permissions for SAS
what are the minimal list of allowed services, allowed resource types and allowed permission to be enabled during generation of SAS for backup\restore on sql managed instance
asked 2020-06-17T19:23:48.24+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, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVO%3C/text%3E%3C/svg%3E)
Veera Oruganti
6
Reputation points
commented 2020-06-25T03:49:28.347+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Moving 7TB of data from Azure IAAS database to Hyperscale
I have got one huge database of 7 TB on Azure IAAS . I am migrated the schema of database to Hyperscale. Now i am planning to migrate data, which service should i use to do the same. I have heard about Database Migration Service, Does that work for…
asked 2020-06-10T13:52:19.49+00:00
Swapnil Solanki
1
Reputation point
answered 2020-06-10T14:49:40.44+00:00
Ronen Ariely
15,106
Reputation points
1 answer
Migration from IAAS to Hyperscale on Azure
I have got one database on Azure IAAS VM, I am planning to move that database to Hyperscale tier of Azure. How can i achieve same or what are the options available,
asked 2020-06-05T14:08:19.787+00:00
Swapnil Solanki
1
Reputation point
commented 2020-06-08T17:56:58.063+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
What source/target pairs does Azure Database Migration Service currently support?
Are both on-premise and cloud hosted instances supported? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question] Source: Microsoft Learn
asked 2020-05-14T16:49:37.2+00:00
Mike Ubezzi
2,776
Reputation points
accepted 2020-05-14T16:59:36.4+00:00
Mike Ubezzi
2,776
Reputation points