What is database migration and describe different types of database migration issues.
Data migration is the process of transferring data from one system or application to
another. Some common issues that can arise during data migration include:
Data loss: Data can be lost due to incorrect data field mapping, conversion errors, or if data is
not transferred.
Data corruption: Unwanted data types can be migrated to the new system, which can damage
the data organization or cause the system to crash.
Data complexity: Data migration can be complicated.
Data security and compliance: Data security and compliance can be an issue.
Dealing with stakeholders: Stakeholders can be impatient.
Disparate data models and formats: When moving data between computing environments, the
source and target infrastructures may use different data models and formats.
Some types of data migration include:
Application migration: Moving data between computing environments, such as when a
company changes its application software or vendor
Database migration: Transferring data between two database systems
Storage migration: Moving physical blocks of data from one type of hardware to another
Business process migration: Transferring information to a new system when two companies
merge, or in response to a competitive threat or changing client expectations
Data center migration: Transitioning from on-premises data centers to cloud environments