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 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 {…
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…
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…
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.
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…
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.
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…
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
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…
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…
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: {…
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…
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:…
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…
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…
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,…
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
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…
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)