- 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.
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.