As you prepare for migrating to the cloud, verify that your source environment is supported and the you have addressed any prerequisites.
1. Pre-Migration Overview:
2. Planing migration methods and Execution phase:
3. Post migration overview:
1. Pre-Migration Overview:
- Find the Database size, it helps us to how long the data copy will take.
- How many schema's and tables going to migrate and check the large objects.
- Database users, roles and privileges.
- How busy/critical of source database.
- Under standing the network, firewalls and security.
- How much down time afford.
- Limitations of source database.
2. Planing migration methods and Execution phase:
- Are we have any additional resources available to assist with various data migration scenarios.
- Relatively small databases that allow for downtime during migration, relatively large databases that can't afford downtime during migration.
3. Post migration overview:
- Developing validation test on both source and target databases using same queries.
- Set up test environment
- Run validation tests against the source and the target and then analyze the result.
- Run the performance tests against the source and target and then analyze and compare result.