Sql Server Migration Framework

SQL Server Migration Framework will help CX/Partners accelerating their Sql Server migration to RDS by providing detailed guidance on how to approach Sql server migration from on prem all the way to RDS.

Discovery Phase

Discovery is the first phase in the migration framework.In this phase the discovery Tool will run against all Sql Server slated for Migration . The tool we will uncover all features that are used in Sql Server on prem that might not be compatible with RDS or RDS Custom for SQL Server like below features

DB Size Limitation ( up to 16 TB )
-No of DB (Up to 100 DB)
-Heterogeneous Linked Server like Sql server To Oracle .
-Sql server Replication
-Sql server Log Shipping
-Extended Stored Procedure
-Filestream
-Resource Governor
-Service Broker Endpoint

Assessment Phase

In this Phase a workload assessmnet needs to run on your on prem Sql servers, the assessmnet will determine your CPU, Memory Workload and capture Totaliops and Throughput.
This is an importnat step before migration, Properly and accurately assessing your workload is important and essential to be able to maximize value from your investments,improve forecasting accuracy and cost predictability, and continuously measure your optimization status. A proper and accurate assessment is essential to properly right sizing your AWS RDS instance to match your workload performance, capacity requirement and save on cost.

.