When performing migration assessment for a large schema (with thousands of objects), you can use the following to help improve performance:
- Run SSMA application on hardware with x64 bit Windows and memory of at least 4 GB.
- Force load the schema information prior performing migration assessment. SSMA, by default, perform “lazy loading” operation by reading minimum schema information from the source database when connecting. During the assessment or conversion operation, it requests additional information to the source database “on-demand”. For full assessment of the entire schema, this results in multiple requests to the server. Depending on the network latency and server status at the time of the request, this may results in significant addition to the time it takes to perform assessment.
To fully load the schema, you can follow these steps:
- Create/Open SSMA project
- Connect to the source database
- Save project
- Specify schema(s) to load and save (note: in addition to the schema you want to perform assessment, you must also include all others you refer in your schema, including (for Oracle) SYS and SYSTEM)