Question: You are migrating a 200 GB database from an on-premise SQL Server to RDS for SQL Server. The database needs to have minimal downtime during the migration. What is the best practice for migrating this database?
- Close all existing connections to the SQL Server database and use Database Migration Service to transfer the data to RDS.
- Use Database Migration Service to replicate the database to RDS and keep it in sync during the migration. Repoint your applications to use the new RDS endpoint.
- Detach the SQL Server database during the migration. Take a backup of the database and use SQ with Accelerated Transfer to upload the backups to S3. Restore the backups to the RDS instance.
- Use the Import and Export wizard within SQL Server Enterprise Manager to create an export task and export the tables to the RDS instance.
Answer: The correct answer of the above question is Option B:Use Database Migration Service to replicate the database to RDS and keep it in sync during the migration. Repoint your applications to use the new RDS endpoint.