What is database migration? And what is the need of migrating a database?
Things that we should consider before migrating a database?
meda Changed status to publish 16/07/2022
Database migration is the process of moving database data to a different environment such as different hardware, operating system, data center, storage architecture ( ASM disk or file system) and database architecture (multitenant) and so on.
And some of the most important things that we should consider before migrating a database includes, but not limited to:
- Backup: We should take full backup of the database before doing migration.
- Testing: Before migrating to a production environment, the database should be tested on the test environment.
- Application and character set compatibility: Application and character set compatibility should also be checked on the test environment before moving to production.
Oracle provides various data migration tools and utilities and some of them includes, but not limited to:
- Data Pump
- Goldengate
- Streams replication
- Data guard
- RMAN
- Transportable tablespace
- Export/import ( old version of data pump)
meda Edited answer 05/04/2022