Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
280 questions
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…
asked 2023-10-20T12:50:30.3533333+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, 38%, 25%)' 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)
Surbhi Sharma
0
Reputation points
commented 2023-11-02T15:16:23.5066667+00:00
GeethaThatipatri-MSFT
27,717
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
asked 2023-10-28T09:45:21.3633333+00:00
Lourival Junior
0
Reputation points
answered 2023-10-28T10:36:08.52+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(134.4, 1%, 23%)' 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)
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!
asked 2023-10-25T07:11:25.8633333+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, 6%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ijaz M
206
Reputation points
answered 2023-10-25T08:53:16.63+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
13,441
Reputation points Microsoft Employee
asked 2023-09-30T16:35:21.2833333+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(291.2, 21%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Sripathi Eravelly
5
Reputation points
edited the question 2023-10-12T15:13:54.2933333+00:00
tbgangav-MSFT
10,386
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 Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
280 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
714 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
![](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(83.2, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sachin Vettiyattil-FT
41
Reputation points
commented 2023-10-12T05:00:53.49+00:00
ShaktiSingh-MSFT
13,441
Reputation points Microsoft Employee
1 answer
During database migration in online mode using Azure data studio status is restoring only on sqlmi.
During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.
asked 2023-10-11T09:35:48.61+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(246.4, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pratibha Agrawal
0
Reputation points
answered 2023-10-11T12:04:41.4+00:00
ShaktiSingh-MSFT
13,441
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…
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
16,471
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
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…
asked 2023-09-05T06:30:44.19+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(3.2, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dakornarayan Chandra
5
Reputation points
answered 2023-09-05T08:09:24.0666667+00:00
ShaktiSingh-MSFT
13,441
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…
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
43,801
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.
280 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.
961 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
869 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
16,471
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
16,471
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
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
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
ShaktiSingh-MSFT
13,441
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
27,717
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
13,441
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
29,896
Reputation points MVP