Wednesday 13 December 2017

What are the differences between Database Migration Assistant (DMA) and Database Experimentation Assistant (DEA)?



S. No
Data Migration Assistant
Database Experimentation Assistant
1
Data Migration Assistants assists you to migrate the database from lower version to higher version
Database Experimentation Assistant is new experimentation solution for SQL server upgrades.
2
It is used for performing the assessment and migration of SQL server databases.
It captures the profiler trace on the source database (Prod) and replays it on the destination servers (NonProd).
3
Two project types are supported:
-          Assessment (Reports on compatibility issues and feature recommendations)
-          Migration (It provides the option to migrate the database with logins to target server)
Three options are currently supported:
-          Capture a workload on the source server
-          Replay the captured workload on target1 and target 2
-          Analyze replayed traces collected from target 1 and target 2
4
Only option is to store the results as (.json or .csv) format
The results can be stored in the database.

No comments:

Post a Comment