SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
368 questions
1 answer
One of the answers was accepted by the question author.
Migration to Azure SQL VM Named Instances using Azure Data Studio Migration Extension
Hi, We are trying to migrate databases using Azure Data Studio Migration Extension. We have an Azure SQL VM with one Default SQL Instance (running on port 1433) and 4 SQL Named Instances (running on dynamic ports). But, ADS Migration Extension…
asked 2022-11-21T15:04:23.913+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(76.8, 27%, 17%)' 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)
Sandeep Sobti
21
Reputation points
accepted 2023-05-17T05:32:44.59+00:00
Sandeep Sobti
21
Reputation points
2 answers
Sql server to Azure postgresql migration Version and Platform Compatibility
Can someone share if any documentation is available for version compatibility comparison for migrating SQL server database to PostgreSQL. Like what SQL server version is compatible with PostgreSQL. Can we migrate SQL server 2008R2,2012 to PostgreSQL 14?
asked 2023-05-05T09:28:53.18+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(281.6, 26%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
ora
21
Reputation points
edited a comment 2023-05-16T04:18:44.6566667+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
14,281
Reputation points Microsoft Employee
1 answer
Azure Database migration service usage for Azure postgres to azure postgres data sync
0 I want to use the Azure database migration service. I have gone through the documentation, but still, I have below questions: Can I use Azure database migration service for transferring data(incremental load) from one Azure Database Postgres SQL to…
asked 2023-05-11T07:16:28.29+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(70.4, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Geetika Talreja
0
Reputation points
commented 2023-05-15T08:21:36.61+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
DMS for MySql single to flexible servers with private endpoints
During trying to perform a migration from mysql to flexible (based on the online migration) I receive this error message when validating source server (which has private endpoints configured) Private access is already implemented into the flexible…
asked 2023-02-22T09:58:32.0166667+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(28.799999999999997, 88%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Assaf L
261
Reputation points
commented 2023-05-11T04:29:43.0833333+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
2 answers
How do I migrate MYSQL Paas Database to a Virtual Machine on Azure ?
How do I migrate MYSQL Paas Database to a Virtual Machine on Azure ?
asked 2023-04-13T09:49:20.44+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(0, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Ankit Negi
0
Reputation points
commented 2023-05-10T23:56:36.5066667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
2 answers
Elastic Query issues in Azure SQL Database not working with private link
I am trying to execute cross database queries in Azure sql .So far the only way I found is with Elastic Query . Unfortunately the Data source which is created as a part of Elastic Query need public network which in my case not possible as I am using…
asked 2023-05-02T20:20:50.8366667+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(67.2, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hemant Singh
0
Reputation points
answered 2023-05-03T17:05:03.7766667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Migrate TFS to ADO services
Hi Team, I currently have Version 17.143.28912.1 TFS server, is this version supproted to migrate the TFS to ADO services?
asked 2023-05-02T13:35:55.5033333+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(198.4, 6%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Madan Krishnan
20
Reputation points
accepted 2023-05-03T12:55:00.25+00:00
Madan Krishnan
20
Reputation points
1 answer
How to connect our on-prem AD to AZURE, after out Exchange Online has already been fully migrated?
We are a non-profit with approx. 650 users and are in an unfortunate situation. We hired a vendor to get us off our failing on-prem 2010 Exchange server, which they did, but now we have Exchange Online and no connection from our on-prem AD to Azure. We…
asked 2023-04-24T17:16:29.25+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(67.2, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Lisa K
0
Reputation points
commented 2023-04-27T13:32:22.56+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
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…
asked 2023-02-28T11:28:45.1133333+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(70.4, 31%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Vlasopoulos V
5
Reputation points
commented 2023-04-25T06:09:09.31+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(124.80000000000001, 28.999999999999996%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JoelP
241
Reputation points
3 answers
One of the answers was accepted by the question author.
How to perform an online migration from SQL Server On-Prem to Azure SQL
Internet provides tons of information how to migrate SQL Server On-Prem databases to Azure SQL. Some headings use the term 'online' and first describe the assessment process which has to be done as a first step. When, however, it comes to the migration…
asked 2023-04-12T09:33:36.8333333+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(105.60000000000001, 10%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rainer Klomps
20
Reputation points
accepted 2023-04-17T14:26:22.5566667+00:00
Rainer Klomps
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Migrate SQL tables with always encrypted column using Azure SQL Migration extension for Azure Data Studio
I am migrating an on-prem SQL database to Azure SQL Database, using tutorial in https://video2.skills-academy.com/en-us/azure/dms/tutorial-sql-server-azure-sql-database-offline-ads as guideline. At the end of migration, those tables containing Always Encrypted…
asked 2023-04-05T04:20:05.15+00:00
Chan Hui Kent
25
Reputation points
accepted 2023-04-10T09:18:36.66+00:00
Chan Hui Kent
25
Reputation points
1 answer
Single Server to Flexible Server PostGIS raster bug
We are trying to migrate an Azure Single Server PostgreSQL 9.6 database to Azure Database for PostgreSQL Flexible Server v14 using the Migration tool. The migration keeps failing with no detailed error message, just: Error while processing. Please…
asked 2023-03-09T06:40:49.6766667+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(124.80000000000001, 11%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWO%3C/text%3E%3C/svg%3E)
WHS One
1
Reputation point
answered 2023-03-29T14:58:15.68+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
SQL failover cluster instance migration to cloud
We have requirement of migrating SQL failover cluster instance to Azure using lift and shift preferably (without much re-engineering or re-architecting) SQL cluster with 2 nodes. (OS - windows 2012 standard, SQL - 2012 sp4) Four SQL cluster…
asked 2023-03-16T05:58:33.8733333+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(262.40000000000003, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Veeramalla Rakesh - (Digital)
41
Reputation points
answered 2023-03-22T19:30:54.6833333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
POC for Oracle database migration to Azure cloud
We wanted to perform POC for Oracle database migration to Azure cloud. Could you please let us know how to push the Oracle RMAN backup to Azure BLOB storage. In Oracle cloud we use "Oracle backup module" to push the on-prem backup to oracle…
asked 2023-03-16T09:28:39.8166667+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(185.6, 41%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Patankar, Narottam
20
Reputation points
commented 2023-03-20T05:57:32.7166667+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
Azure Data Studios Azure SQL Migration hangs with Restoring Migration Status
I am attempting to migrate a trivial database from an on-prem SQL Server 2019 instance into Azure using the Azure SQL Migration extension for Azure Data Studio. I am trying to migrate to an instance of SQL Server on Azure Virtual Machine. I am able to…
asked 2023-03-10T18:57:31.64+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, 41%, 38%)' 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)
Matthew Snook
0
Reputation points
commented 2023-03-14T14:34:08.34+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
How to fix Could not load type 'DTSTransform.SCD.6' from assembly 'Microsoft.SqlServer.PipelineHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
I'm trying to run an Integration Services Assessment using the Data Migration Assessment tool, however, when selecting the folder containing my .dtsx packages. The assessment runs mostly fine, but I am getting this error: The managed pipeline component…
asked 2023-01-24T16:31:24.3833333+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(163.2, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bill LaLonde
30
Reputation points
commented 2023-02-20T21:14:49.0066667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
0 answers
Error on SQL DB migration using Azure data studio
Hi Im using Azure data studio to migrate SQL DB to Azure MI , i put the backup .bak file on the storage account but the migration proceess is failing with the below error, all the others DB's were migrated successfully.
asked 2023-02-17T18:53:46.33+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(304, 83%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hector Huerta Tricolor
106
Reputation points
edited the question 2023-02-18T04:55:18.3966667+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(288, 47%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AjayBathini-MSFT
40
Reputation points Microsoft Vendor
1 answer
Assessment failed during Code compatibility collection Failed to parse Ora2pg version
while doing code assessment for database migration from oracle to postgres on azure studio getting error related Assessment failed during Code compatibility collection Failed to parse Ora2pg version. Contact Microsoft support for further assistance
asked 2023-02-08T09:54:57.9166667+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, 23%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
shivendra narain nirala
6
Reputation points
commented 2023-02-15T06:41:28.3866667+00:00
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
What are the tools available for ONLINE and OFFLINE migration with minimal downtime for Oracle to MSSQL database
Please let us know the available migration tools/services which can use for database migration from ORACLE to MSSQL with ONLINE/OFFLINE.
asked 2023-01-23T16:06:19.74+00:00
Indu Srinivas
20
Reputation points
accepted 2023-02-13T07:25:38.45+00:00
Indu Srinivas
20
Reputation points
1 answer
SQL Server Migration Assistant (SSMA) for DB2 Vs SQL Server Migration Assistant for Oracle
Hello All, Requesting information regarding SSMA. We are migrating our existing DB2 to Azure SQL. With regard to this we are trying to understand SSMA application which helps us in migration. We referred various documentation with regard to this. We…
asked 2023-01-23T05:16:37.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(147.20000000000002, 95%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
AKSHAY RANGA
11
Reputation points
commented 2023-02-08T05:06:04.21+00:00
AKSHAY RANGA
11
Reputation points