Azure database for MySQL - foreign key checks option
Hello M, Can you help us with a variable to manage the foreign_key_checks option is basic variable to migrate data.
Migration of On-Prem SQL Servers to Azure
Hello, I have 2 On-prem SQL Servers (One is primary server and other is Secondary server). SQL version is 2016 and edition is Enterprise. I have configured always-on for 10 big databases under multiple AAGs. Now I want to migrate my both On-Prem SQL…
Free tier database only lasts half the month
The database is very simple, barely has any data or any calls being sent to it. Seems like a near empty unused database should not even last less than half a month on a free plan. Am I doing something wrong? It seems there is some sort of 'health event…
Azure DMS - point applications at target DB before cutover
When running an online migration with Azure Database Migration Service, are there any issues with pointing applications at the target database before running the cutover in DMS? In the cutover action in DMS it says to stop writes on the source DB to make…
How do I resolve this message: Management operations are not allowed until migration is committed or aborted.?
I am performing a migration for Classic Storage Accounts to Azure Resource Manager, and on one of my Accounts, I am getting this message: Management operations are not allowed until migration is committed or aborted. I am unsure how to resolve this.
Cloning an Azure Cosmos DB collection with Gremlin API
What is the best way to clone data from one Azure Cosmos DB collection to another using the Gremlin API? I'm considering using the Azure Data Migration tool, but I'm not sure if it will work in this case. Any suggestions would be appreciated.
Error during online migration of Postgres single server (v10.23) to flexible server (v16)
I attempted to perform an online migration on one database from a Postgres single server (v10.23) to a flexible server (v16), but encountered an error while reading the WAL logs. The error message states that "pgcopydb failed with unknown…
Importing csv into Azure Data Studio taking forever
I tried to upload csv file into azure data studio using import flat file wizard extension. However, it has been loading forever. Could you suggest what I should do?
MongoDB Atlas for Azure
I am trying to subscribe to Mongo’s private plan in CSP subscription. Can anyone please assist if this purchase is available for CSP subscriptions?
Azure Database Migration Services (LRS), target node restart
Hopefully a quick one, We're using Azure DMS to migrate from 1 SQL server to another - both are SQL Server on Virtual Machines. LRS is setup and running using Azure Blob storage - Full backups nightly, 5 minute Tlog backups on the source server. We have…
Not able to create Azure Database Migration Project
I need to create Azure Data Migration Project for one of my assignments, But I'm not able to do it from the Portal. No option for Creating a project is present. Previously I used to create it through Database Migration Services, But I'm not able to do…
Azure SQL DB Sync with other databases is greyed out
I got same question, I was trying to transfer data from dynamic crm to On-Premises local sql server db, I put this azure database as middleware, first transfer data from crm to azure database, then try to using Azure database sync group to sync Data to…
End to End Migration of On-Premises to Azure
Need real time case study with End to End Microservices design, development and deployment in .NET Technology
Online Oracle to azure PostgreSQL migration
Hi, We are planning to migrate 2TB Oracle database from on prem to Azure PostgreSQL. For schema conversion and migration we are planning to do with Ora2PG or Ispirer. Where we will convert schema and objects under them using one of these tools and…
Offline Migration to postgreSQL flexible server failes with extension creation error
Migrating my PostgreSQL Single Server to Flexible Server does not work. The error message is as follows: One or more errors occurred while migrating 'xxx' : EX001: Extension creation failed for the following extensions: hypopg, pg_buffercache,…
Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL Databases that hold the data used and consumed by ADF pipelines
Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL databases that hold the data used and consumed by ADF pipelines. Can we migrate and move pipelines created in Azure Data…
Data Migration between two sql server using the Data Migration Assistant Tool
UseCase- I am performing Data migration between the two sql server using the Data Migration Assistant tool. i.e I am migrating the Data from sql server1 to sql server 2 Case works Fine- Data Migration using the DMA tool works fine when performing the…
Migração Azure for Postgres Flexivel
Boa noite, estou com um projeto para migrar os dados do meu PaaS Postgres Flexível com ip publico para uma nova instância idêntica do PaaS Postgres Flexível com Ip Privado, seria possível realizar essa demanda através do Azure Database Migration Service?…
How to create Newer Version of Azure Database Migration Service using PowerShell
The retirement of Azure Database Migration Service (classic) for SQL Server scenarios requires migrating to the latest Azure Database Migration Service version. However, the New-AzDataMigrationService command still creates the classic version. What…
I have few confusion for SQL migration from OnPrem to Azure in between DMA/DMS/ Data studio & Azure Migrate
I have the below queries If Azure Migrate Readiness Report Recommend Onprem DB into Azure SQL Managed Instance & at onprem location, DMA was set up. In that case, is it required to set up Data Studio also at the on-prem location, as DMA does not…