Migration VMs versus Replication of VMs on AWS
Migration Only
For just migration capabilities, we can use vCenter plugin for vCenter (the on premises piece). This will not do ongoing replication.
Ongoing Replication
For ongoing replication, we use Server Migration Service.
SQL Server Only Replication
If all you care about is SQL Server replication, then you can use either native SQL Server Replication or AWS Data Migration Service.
Native SQL Server Replication (Always On Replication)
No real downsides – unless going from an unencrypted to an encrypted (or vice versa) database. In that case, this will not work
AWS DMS – Bulk Load Data with Ongoing Replication
- Tasks with Migration Validation
- Tasks can pick up where they left off in case of network outages etc.
- Can go to Multi AZs as well – if one AZ DMS service is down, the other one picks up the replication
- Can also go to Aurora or Redshift directly instead of RDS
Steps – DMS Service
- Create a Replication Instance
- Connect a SRC and TARGET database
- Create Tasks
Steps – Source SQL Server
- Enable Replication for the DB using sp_replicationdboption
- Create a publication artefact with a 1 = 0 filter for the database (for logging all transactions to txaction log)
- Use fn_dblog() and fn_dump_dblog() functions to read changes from the transaction log to the LSN
DMS Pricing
https://aws.amazon.com/dms/pricing/
Migration Only
For just migration capabilities, we can use vCenter plugin for vCenter (the on premises piece). This will not do ongoing replication.
Ongoing Replication
For ongoing replication, we use Server Migration Service.
SQL Server Only Replication
If all you care about is SQL Server replication, then you can use either native SQL Server Replication or AWS Data Migration Service.
Native SQL Server Replication (Always On Replication)
No real downsides – unless going from an unencrypted to an encrypted (or vice versa) database. In that case, this will not work
AWS DMS – Bulk Load Data with Ongoing Replication
- Tasks with Migration Validation
- Tasks can pick up where they left off in case of network outages etc.
- Can go to Multi AZs as well – if one AZ DMS service is down, the other one picks up the replication
- Can also go to Aurora or Redshift directly instead of RDS
Steps – DMS Service
- Create a Replication Instance
- Connect a SRC and TARGET database
- Create Tasks
Steps – Source SQL Server
- Enable Replication for the DB using sp_replicationdboption
- Create a publication artefact with a 1 = 0 filter for the database (for logging all transactions to txaction log)
- Use fn_dblog() and fn_dump_dblog() functions to read changes from the transaction log to the LSN
Leave a Reply