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.
|
This blog is home of my experience,findings and views on Learning New technologies
Wednesday, 13 December 2017
What are the differences between Database Migration Assistant (DMA) and Database Experimentation Assistant (DEA)?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment