Showing posts with label Database Experimentation Assistant(DEA). Show all posts
Showing posts with label Database Experimentation Assistant(DEA). Show all posts

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.