Please enable JavaScript.
Coggle requires JavaScript to display documents.
2.1 migration - Coggle Diagram
2.1 migration
Migrate databases
-
pricing tiers
- Standard:
Supports only offline migrations. There's no charge to use this tier.
- Premium:
Supports both offline and online migrations. There's no charge for the first six months. After that period, you'll incur charges.
Destinations
- Single Azure SQL Database instance:
A fully managed, single SQL database.
- Azure SQL Database managed instance
- SQL Server on Azure Virtual Machines
- Azure Database for MySQL
- Azure Database for PostgresSQL
- Azure Cosmos DB
- Download the Data Migration Assistant: on-premises servers running SQL Server.
- Create an Azure Virtual Network instance
- Configure the network security group: allow inbound connectivity to the service via ports 443, 53, 9354, 445, and 12000.
- Configure the Windows Firewall: port 1433 1434
- Configure credentials:
- Add CONTROL SERVER permissions to the credentials used to connect to the source SQL Server instance.
- Add CONTROL DATABASE permissions to the credentials used to connect to the target Azure SQL Database instance.
- Provision your target database in Azure
Using the Data Migration Assistant, create an Assessment project
-
-
-
- create a new Migration project
- select the 2 servers
- Set the scope of the migration to Schema Only
- Deploy Schema
- Create an instance of Azure Database Migration Service. Choose the pricing tier
- Create a new migration project
- Specify source and target server details, including the authentication information.
- Identify the databases
- Run and monitor the migration.
- Select the Run migration button to start the migration
- Track the progress
- After all the required databases are migrated, check them to make sure they're working.
Azure Migrate
Assess your environment:
- agentless environment discovery
- agents to perform a dependency analysis.
-
-
-
-
portal: Assessments section, and then select Create assessment
Migrate servers
-
-
-
-
- review the security settings (firewall, Azure Disk Encryption)
- backup
- Replicating
-
azure VM, hyper-V, vmware, phisical win
-
app
- rehost
- refactor (PAAS)
- rearchitect
- rebuild
- replace
-
-
Azure Site Recovery
- Prepare the source (vCenter Server) and target (Azure) environments.
- Set up and start the replication between the two.
- Test that the replication has worked.
- Fail over from the source servers to Azure.
workloads
- start with small migratio, no business critical
-
-
-
-
Assess, Migrate, Optimize, and Monitor