- How to identify workload ? testing performance issue ?
- Before migration what i have to check in the VM ?
- after migration any db setting need to change ?
Asked
Active
Viewed 1,088 times
-1
David Makogon
- 69,407
- 21
- 141
- 189
jega
- 1
- 1
-
Unfortunately this question is off-topic for Stack Overflow. it's very broad (and contains several questions). Also, it's not a programming question (might be something for the dba stackexchange or serverfault, but not sure if it's on-topic there). And I'm not sure there's a single answer for any of this. – David Makogon Jun 19 '19 at 04:29
1 Answers
0
Your question is broad. Generally, you could work on the Azure VM as usual as you do on your on-premise VM.
Before your migration, you could consider what sizes of Azure VM suitable for your SQL server and OS server version is supported on Azure VM. See the sizes for Windows virtual machines in Azure. Also, you may want to test for SQL Database compatibility issues before you start the migration process referring to this blog.
You could migrate on-premises SQL Server or SQL Server on Azure VMs to Azure SQL Database using the Data Migration Assistant. Here are the step-by-step instructions on this tool. You also could use Azure backup service to back up Azure IaaS VMs.
More references:
Nancy
- 26,865
- 3
- 18
- 34