287 questions with Azure Database Migration service tags

Sort by: Updated
2 answers

Reliable way for AWS Aurora PostgreSQL to Azure PostgreSQL migration

Hello community members, Looking for an approach for migrating live AWS Aurora PostgreSQL database in Azure. As Azure DMS doesn't support this as a source but given Aurora is built on top of PostgreSQL, what are possible ways considering need is to…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2023-09-28T04:38:57.9233333+00:00
Rohit Agarwal 5 Reputation points
answered 2023-12-13T05:22:40.53+00:00
Vishwesh 0 Reputation points
1 answer

Not being able to connect to my aws rds database from data migration assistant

I am trying to migrate data from aws rds to azure sql managed instance but i having error while connecting to my target server (aws rds). I am using <endpoint>,<port> notation. This is the error i am facing: Connection to the server…

Azure Database Migration service
Azure SQL Database
asked 2023-12-12T12:10:14.9933333+00:00
Nischay 0 Reputation points
edited an answer 2023-12-12T17:04:42.0133333+00:00
Alberto Morillo 33,341 Reputation points MVP
1 answer One of the answers was accepted by the question author.

Retirement notice: Database Migration Service (classic) - SQL scenarios retirement by 15 March 2026

Azure Database Migration Service (classic) - SQL Server scenarios will not be supported after 15 March 2026. Beginning 01 August 2023, you will no longer be able to create new Database Migration Service (classic) resource for SQL Server scenarios.…

Azure Database Migration service
Azure SQL Database
asked 2023-03-17T19:30:29.1833333+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee
commented 2023-12-07T08:49:56.58+00:00
Abhishek Kumar 0 Reputation points Microsoft Employee
1 answer

How to Migrate Oracle from One Azure Subscription to Another Azure Subscription

How to Migrate Oracle from One Azure Subscription to Another Azure Subscription How to Migrate SQL from One Azure Subscription to Another Azure Subscription How to Migrate MYSQL from One Azure Subscription to Another Azure Subscription How to Migrate…

Azure Database Migration service
asked 2023-11-29T22:12:49.27+00:00
Sukhen Tiwari 0 Reputation points
commented 2023-12-04T06:15:09.0766667+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
1 answer

Moving a subset of data from one Cosmos db container to other

Hi all, I am looking for migrating a subset of data from one of the Containers to another in same Azure account. I have 2 containers: AccountDetails and Users. Both containers have their respective data rows. As per the requirement, I need to have few…

Azure Database Migration service
Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
669 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,518 questions
asked 2023-11-15T19:33:29.5366667+00:00
Rajan Mishra 0 Reputation points
edited a comment 2023-11-15T22:53:34.3466667+00:00
GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
1 answer

Azure database for PostgreSQL Single Server migrate of large database of 3 TB size

I would like to migrate large database upto 3TB to new flexible server, Problem 1: my existing database collocation "Thai" not support show output languages miss math mean "UFO Charecter cannot read" Problem 2: During migration…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2023-11-15T03:45:53.78+00:00
Wutiklai Chapanya 0 Reputation points
answered 2023-11-15T08:46:46.9533333+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

How to migrate Oracle database RMAN backup from one Azure subscription to another.

Hi, We have one Oracle EBS database running in on Azure's Production subscription. We want to build a standby database in Azure's Dev subscription. How can we achieve this. Regards, Narottam

Azure Database Migration service
asked 2023-09-29T12:20:27.0233333+00:00
Patankar, Narottam 20 Reputation points
accepted 2023-11-10T09:51:00.55+00:00
Patankar, Narottam 20 Reputation points
2 answers One of the answers was accepted by the question author.

PostgreSQL single server to flexible server migration error - permission denied for admin user

When I am doing migration of 3 databses(schemas), between single server and flexible server postgresql I am getting error shown below Data migration could not be started for one or more of the DBSets. Error details: PGv2RestoreError: PG Restore…

Azure Database Migration service
Azure Database for PostgreSQL
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
asked 2022-11-04T16:03:06.997+00:00
Nowakowski Krzysztof 21 Reputation points
answered 2023-11-03T13:45:31.37+00:00
devopsfj 196 Reputation points
1 answer

I am unable to see my azure sql migration extension in the azure data studio.

I am unable to see my azure SQL migration extension in my azure data studio. I have installed the Azure SQL Migration extension but unable to see in the data studio even I tried restarting the data studio. I am following this Microsoft document where i…

Azure Database Migration service
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
asked 2023-10-20T12:50:30.3533333+00:00
Surbhi Sharma 0 Reputation points
commented 2023-11-02T15:16:23.5066667+00:00
GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
1 answer

Moving Files from Azure VM to Sharepoint

I have a 8TB disk File Server VM in Azure. I am planning to migrate the content to Sharepoint. Which is the best way to do that to not have expansive costs with traffic consumption? Regards, Louri

Azure Database Migration service
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,472 questions
asked 2023-10-28T09:45:21.3633333+00:00
Lourival Junior 0 Reputation points
answered 2023-10-28T10:36:08.52+00:00
suraj sharma 85 Reputation points
1 answer

How to fix the error 'running command dataExplorer.restore: s.getOptionsKey is not a function' that popus up while trying to restore a database using Azure Data Studio

This is the error that is displayed as soon as I try to restore a database on Data Studio. TIA!

Azure Database Migration service
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
asked 2023-10-25T07:11:25.8633333+00:00
Ijaz M 206 Reputation points
answered 2023-10-25T08:53:16.63+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
asked 2023-09-30T16:35:21.2833333+00:00
Sripathi Eravelly 5 Reputation points
edited the question 2023-10-12T15:13:54.2933333+00:00
tbgangav-MSFT 10,416 Reputation points
0 answers

How to fix Error Code: 1478. InnoDB : A partitioned table is not allowed in a shared tablespace while migrating to MySQL Flexible Server from MySQL Single Server

We are planning to migrate mysql single server to flexible server, while doing so using data migration service in offline mode we encountered the below error for few the tables which had partition. The error message is The pipeline failed to prepare…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
Azure FastTrack
Azure FastTrack
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.FastTrack: This tag is no longer in use. Please use 'Azure Startups' instead.
75 questions
asked 2023-10-10T11:09:24.36+00:00
Sachin Vettiyattil-FT 41 Reputation points
commented 2023-10-12T05:00:53.49+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
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…

Azure Database Migration service
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,631 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 {…

Azure Database Migration service
asked 2023-08-19T18:42:16.87+00:00
Su, Hong [Admin] (US) (US) 10 Reputation points
commented 2023-09-14T16:43:27.17+00:00
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…

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,014 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2022-11-07T04:37:13.36+00:00
Hemanath Goud Kandula 1 Reputation point
commented 2023-09-05T11:45:15.9866667+00:00
Muhammad Sohail Nawaz 0 Reputation points
1 answer

Azure MySQL single server got auto migrated to flexible server

I have an Azure MySQL single server which got auto migrated to flexible server and currently in stopped state because of which I can't change any settings or can't access it from any client application, when opening in azure portal its showing message…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
asked 2023-09-05T06:30:44.19+00:00
Rakesh Dakornarayan Chandra 5 Reputation points
answered 2023-09-05T08:09:24.0666667+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
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…

Azure Database Migration service
Azure SQL Database
asked 2023-08-23T21:25:39.6733333+00:00
edited the question 2023-09-04T14:10:22.12+00:00
Sumarigo-MSFT 44,906 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
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,056 questions
Azure Database for PostgreSQL
asked 2023-08-24T14:57:05.9233333+00:00
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…

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
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,631 Reputation points Microsoft Employee