Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
287 questions
2 answers
Can we create mongo db seperate service as like sql database from azure portal..????
Hello , Can we create mongo db seperate service as like sql database from azure portal.
asked 2023-08-14T12:14:24.4833333+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(51.2, 0%, 14%)' 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)
Shrikant Alone
20
Reputation points
answered 2023-08-16T17:06:59.1066667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
how to fix Error type Failed to connect Error Detail Error 258 - SQL connection failed. with source sql server
While creating new migration project in Data Migration Service. in select source i'm getting this error. instance credential is correct, enabled tcp/ip, remote connections are allowed. failed to connect. Error type Failed to connect, please check error…
asked 2023-08-10T04:55:26.1733333+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, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pradeep Pal
0
Reputation points
commented 2023-08-16T01:18:24.8566667+00:00
LiHongMSFT-4306
25,326
Reputation points
1 answer
How does Cosmos db mongodb perform cross region and cross account online Data migration
What tools or solutions can I use to migrate Cosmos DB mongodb data online and across accounts and subscriptions in Azure
asked 2023-07-27T10:14:23.2166667+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, 6%, 31%)' 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)
渔歌子
0
Reputation points
commented 2023-07-31T04:56:44.84+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, 4%, 31%)' 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)
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
2 answers
Migrating DB2 tables from IBM Public Cloud to SQL Server in MS Azure
I'm working on a project that is migrating thousands DB2 tables to SQL server in MS Azure using SSMA tool. 99,9% of tables were migrated with success, however, a couple of DB2 tables containing columns set as binary 'CHAR() FOR BIT DATA (13)' are not…
asked 2023-07-27T17:32:08.81+00:00
ROBERTO ALVES PEREIRA
20
Reputation points
answered 2023-07-28T12:08:13.36+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to better set up the SQL Server Migration Assistant (SSMA) tool in order to enable loading huge tables (+1.5 Billions of rows) from DB2 (IBM Public cloud) to SQL server (Azure).
I'm working in a project to copy huge DB2 tables (1.5 Billions of rows) from DB2 (IBM Public Cloud) into the SQL server (Microsoft Azure cloud). I'm using SSMA (SQL Server Migration Assistant) tool installed in a VM in Azure as 'middle-man' to access…
asked 2023-07-05T18:04:26.3966667+00:00
ROBERTO ALVES PEREIRA
20
Reputation points
answered 2023-07-27T16:01:09.1766667+00:00
ROBERTO ALVES PEREIRA
20
Reputation points
2 answers
Database Migration Service - Atlas MongoDB
Hi, I cannot use Atlas MongoDB as a source for a database migration. The connection fails with the following message: {…
asked 2023-07-23T00:05:26.5966667+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(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Rafael Carinha
0
Reputation points
commented 2023-07-26T05:01:38.3466667+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
How to load data from DB to adls/Blob partitioned
Hi Experts, I have a database in on-prem that contains data for 15 years and not used frequently. I want to store this data in ADLS or Blob Stoarge in azure to reduce cost. The requirement is that the data should be migrated from on-prem to azure cloud…
asked 2023-07-24T00:59:32.6133333+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(166.4, 39%, 26%)' 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)
Saha
0
Reputation points
commented 2023-07-25T12:36:17.8633333+00:00
Nandan Hegde
30,716
Reputation points MVP
4 answers
One of the answers was accepted by the question author.
Upgrade Azure Database for PostgreSQL from version 9.6 to 11
Hello, we are planning to upgrade our Azure Database for Postgres (single server) from the version 9.6 to 11. we wish to use DMS, but in the DMS documentation:…
asked 2021-02-22T11:16:26.013+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(108.80000000000001, 35%, 20%)' 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)
SHABOU Malek
46
Reputation points
answered 2023-07-23T13:59:31.0433333+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, 7.000000000000001%, 31%)' 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)
si li
20
Reputation points
1 answer
Is it possible reverse Sync databases from Azure SQL managed Instance to On-premises SQL Server 2019
Hi Team, We have been migrating the databases from on-premises SQL server to Azure SQL MI using Azure data Studio. Is there any migration tool to migrate the databases from Azure SQL MI to On-premises SQL server? Is it possible reverse sync data between…
asked 2023-07-03T10:13:01.32+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, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thyagarajulu B M
121
Reputation points
commented 2023-07-20T16:58:27.2466667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
How to migrate to workspace-based application insights
I refer to a recent email from Microsoft with this headline: Classic application insights will be retired on 29 February 2024—migrate to workspace-based application insights I tried contacting the guy who set up the website for us about this but he did…
asked 2023-07-17T15:09:15.08+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(307.2, 30%, 39%)' 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)
Abby
1
Reputation point
answered 2023-07-18T00:04:56.6266667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
0 answers
Accessing my data base/code
Completely new to Azure. Development team said they completed migration over to our Azure account. Unfortunately our development team had to abruptly leave the project. We have access to our account that they said they completed migration to, however,…
asked 2023-07-14T00:56:53.81+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, 57.00000000000001%, 24%)' 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)
Swing Social
0
Reputation points
commented 2023-07-17T03:41:15.55+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
SQL Server to azure postgresql
Please share any document which can give information about the compatible Azure PostgreSQL versions for migration of SQL server versions 2012,2014,2016 and 2019 from on premise
asked 2023-07-12T09:37:45.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(281.6, 26%, 37%)' 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)
ora
21
Reputation points
commented 2023-07-14T09:46:27.0466667+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
3 answers
Does Azure DMS support Cross-Tenant migration?
Hi guys, I am trying to test the migration of Azure DB for MySQL Single from one tenant to MySQL Flex on another tenant&subscriptions. I know it support migration from one region, subscription, ResourceGroup to another, but not sure if this support…
asked 2023-06-29T09:20:45.7733333+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(294.40000000000003, 85%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Sanghoon Yang
0
Reputation points
commented 2023-07-14T06:52:06.3933333+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure postgres to on premise postgres
HI, We are in process of migrating the postgres on premise to azure postgres . Currently defining our rollback strategy we need to know if there any way to migrate the database changes from azure to on premise (in-case we need a rollback)
asked 2023-07-05T14:40:55.6533333+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(288, 63%, 37%)' 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)
Salim Mohammed Ali
20
Reputation points
accepted 2023-07-06T05:08:22.03+00:00
Salim Mohammed Ali
20
Reputation points
1 answer
Migration of data from azure cosmos db to on premise mongodb
Hi , We are planning to migrated the data from azure cosmos nosql database to on premise mongodb .we have generated bson files for each container and tried to import to mongodb locally. But can we convert the data from azure aligned to the mongodb…
asked 2023-06-23T11:24:47.87+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(233.6, 51%, 32%)' 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)
Sri
0
Reputation points
commented 2023-07-03T06:46:45.87+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Migrate AWS Data Pipelines to Azure
We have a new project kicking off in next couple of days. One of the main requirements is to migrate AWS data transformation pipelines to azure. would appreciate if you could share any case study examples, books for us so that we could do some…
1 answer
One of the answers was accepted by the question author.
Migrate .bak file to azure sql
Hi, We have requirement to migrate data from .bak file to azure sql. I have tried to see documentation but could find migration using .bak file. Can we migrate data using .bak file to azure sql? Thanks
asked 2023-06-14T20:05:09.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(156.8, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vikas Tiwari
766
Reputation points
commented 2023-06-19T04:08:18.1966667+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
No full backup file present or Database Migration service could not access the file
I am migrating my on-premise SQL server to Azure SQL MI using Azure DMS. I have provided the full database backup to my SMB network share path. I have successfully created Azure Database Migration Project under Azure Database migration Service,…
asked 2022-02-08T13:00:27.36+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
edited the question 2023-05-30T13:08:38.75+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
How can we find the table definition is a synapse dedicated SQL pool.
I required the definition of all tables in my synapse dedicated SQL pool I tried to look into the sys metadata tables but did not find a solution. Please help me here if there is any possible way is there to get the definitions of the available tables.
asked 2022-07-15T06:12:00.837+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, 67%, 37%)' 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)
Singh, Shiv Bhole
6
Reputation points
commented 2023-05-26T17:45:16.4733333+00:00
sekhemrekhutawysobekhotep
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Migration to Azure SQL VM Named Instances using Azure Data Studio Migration Extension
Hi, We are trying to migrate databases using Azure Data Studio Migration Extension. We have an Azure SQL VM with one Default SQL Instance (running on port 1433) and 4 SQL Named Instances (running on dynamic ports). But, ADS Migration Extension…
asked 2022-11-21T15:04:23.913+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(76.8, 27%, 17%)' 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)
Sandeep Sobti
21
Reputation points
accepted 2023-05-17T05:32:44.59+00:00
Sandeep Sobti
21
Reputation points