How can I can create a new table in a database already made empty. VB 20017 SQL Express
I am learning Visual Basic 2017, and I created an empty database without a table. So, now I would like to learn how to add a table to the new database. The database that I created is SQL Express, and I am using ADO.net. There is somebody in here who can…
Guidance with MariaDB migration to Azure
Hello, I am currently looking at migrating a MariaDB database hosted on AWS over to Azure as part of a cloud consolidation program. While Azure Database for MariaDB would seem like the most suitable choice, Microsoft has announced that this service will…
PostgreSQL Flexible Server Not Appearing After Automatic Migration
Hello, My Azure Database for PostgreSQL Single Server was scheduled for migration to an Azure Database for PostgreSQL Flexible Server on August 31, 2024. However, the old PostgreSQL Single Server has now been deleted, and I am unable to locate the new…
SQL server databases migration to Azure SQL VM using Azure Data studio
Hello, I am migrating the SQL server databases to Azure SQL VM using Azure data studio but step 6 - validating the connectivity failed with below error. I am able to connect to SQL server using SSMS from same server. I can be able to see the…
Migration From Physical SQL Server Windows 2012 To Azure
Hi All, I have a On prem physical SQL Server running windows 2012. I have site to site connectivity already establishes. The SQL Server is running ABOUT 30 DB. Our goal is to completely migrate the DB so we can decommissions the on prem server. I…
PostgreSQL Single server to Flexible server fails on BYPASSRLS
Hello, We're using the Azure Database Migration service to migrate our Azure PostgreSQL Single server to a Flexible server. It fails with the following message: "Failed to execute query `ALTER ROLE "dummyAdmin" WITH BYPASSRLS;` with…
how to migrate data from on-premise sql server to azure postgresql
we have tried to migrate data from on-premise SQL to azure PostgreSQL by using database migration service but we are not able to select target as PostgreSQL when source is SQL server.
Monitoring and alerting setup on the Taks (Online data migration) of service Azure Database Migration Services ?
Hi Team, I have a Azure Database Migration Services in which i have created Azure Database Migration Project under that we have Three Online data migration tasks which sync db from aws to azure. but when anyone of task is getting failed am not getting…
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…
Can't see or access database server after automatic migration
After automatic migration of our Postgres single database servers to flexible servers that started 14.09. and lasted until 20.09. i can't see new database servers in my resource group. I can access database through power shell but not from the…
What are some different methods to restore/copy/migrate Azure SQL Database across subscription and across the server?
I'm just trying to access different methods to migrate my SQL database from one subscription to another
Does it possible to move a MySQL database between different Azure Accounts?
Hi all, I have 2 different Azure Accounts. I want to move the mysql database in one of these Azure accounts to my other Azure account. Since the database is approximately 150 GB, I would like to do this with the Azure recommended or best practice method…
How to defer a scheduled migration of my Single Server to Flexible Server?
Q: How do I defer Microsoft's scheduled migration of my Single Server to Flexible Server. A: From Microsoft: Issue: Below is an image of what I see in Azure migration section. How do I defer the date? Do I click the "Start Migration"…
Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.
In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…
Postgre SQL Automigration 8 Databases Limit
When migrating my server manually, I can only migrate 8 databases, but now 2 servers will be migrated automatically from Single server to Flexible on 07.09. What happens to the databases if there are more than 8 databases?
Migration for azure db postgresql single server to azure sql
Hello there, Goodday! Our current db workload was placed in azure db postgresql single server. We need to migrate this postgresql single server to azuresql since not compatibility for our running application(atlasianjira) with flexible server in…
Azure Managed Instance Migration offline mode. Cannot find full back up error
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…
Data validation tools while migrating on-prem oracle DB to Azure SQL DB
I have to migrate/copy data from oracle database in on-premise to azure SQL database. May I know if Microsoft provides a tool or utility that helps data validation, schema validation and checksum validation of data between oracle database and Azure SQL…
Azure Database for MySQL In-Place Auto Migration Failure: Migration timeout in step: wait until replication lag below threshold
Hi, We have scheduled an in-place auto migration for Azure Database for MySQL in order to migrate from a single server to a flexible server. It was scheduled to migrate on August 16th, 2024 (1:00 a.m. P.S.T.–8:00 a.m. P.S.T.). However, we got a…
messages_update_notify () not working after migrating from single server to flexible server
We recently migrated Azure postgres from single server to flexible server . There is a Trigger which are using function messages_update_notify () not working after migrating from single server to flexible server. is NOTIFY deprecated in Azure flexible…