Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
291 questions
1 answer
bacpac restore Issue to Azure DB:Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.
Receiving error below when restoring a DB to Azure *** Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database. Warning SQL0: A project which…
asked 2023-07-20T18:49:00.8566667+00:00
Dan J. Meyer
0
Reputation points
commented 2023-09-27T20:39:38.14+00:00
Oury Ba-MSFT
17,946
Reputation points Microsoft Employee
1 answer
Azure DMS to migrate MongoDB to Cosmos for MongoDB, with bulk-write error
I am using Azure DMS to migrate MongoDB database from Azure VM to CosmosDB, after create project and migration action, I have following 2 kinds of errors : bulk-write error {…
asked 2023-08-19T18:42:16.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(99.2, 67%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Su, Hong [Admin] (US) (US)
10
Reputation points
commented 2023-09-14T16:43:27.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(220.8, 78%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vaikakkara, Anoop
46
Reputation points
1 answer
Connection String for Ms Access in ADF Linked Service
I have been trying to create MS Access Database Linked Service in Azure Data Factory. I have used the below formats for creating the MS Access linked services in Azure Data Factory: Provider=Microsoft.ACE.OLEDB.12.0;Data…
asked 2022-11-07T04:37:13.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(176, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
Hemanath Goud Kandula
1
Reputation point
commented 2023-09-05T11:45:15.9866667+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, 62%, 31%)' 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)
Muhammad Sohail Nawaz
0
Reputation points
2 answers
What Azure services to use to export Table data from Azure sql to a flat file securely.
Flat file should be stored in a secured place in some azure services. No transformation required during export & No manual querying from azure or no manual uploading of flat file. Import of flat file may be done by consumer by manually downloading it…
asked 2023-08-23T21:25:39.6733333+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(179.20000000000002, 67%, 27%)' 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)
Christopher Disilva Hirudayanathan
5
Reputation points
edited the question 2023-09-04T14:10:22.12+00:00
Sumarigo-MSFT
45,491
Reputation points Microsoft Employee
1 answer
Migrating PostGres Databases Between Instances Using Database Migration Services
I am attempting to use the Azure database migration services, but I am experiencing issues when creating the project. I cannot really find the documentation I am looking for or I missed when reviewing the documentation that I found.
Azure Database Migration service
Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
291 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,074 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
952 questions
asked 2023-08-24T14:57:05.9233333+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, 5%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bradley Soverns
0
Reputation points
commented 2023-08-28T18:04:29.35+00:00
Bradley Soverns
0
Reputation points
2 answers
Data Migration Assistant, assessment upload fails
We're about to migrate a few databases to Azure SQL Databases. Steps taken: created an azure migrate resource in our subscription (running with a private endpoint in one of our vnets, accessible over a vpn tunnel) updated the…
asked 2021-09-24T09:39:29.937+00:00
Tobias Lolax
11
Reputation points
commented 2023-08-23T16:01:22.5933333+00:00
Oury Ba-MSFT
17,946
Reputation points Microsoft Employee
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,946
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,651
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,406
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,017
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,406
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
31,436
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,017
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,017
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,406
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,406
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,406
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