Database migration processes and optimization using BSMS (bank staff management system)

Databases are essentially a storage technology designed to handle complex data dependent tasks, and to perform these tasks, data-integrity is important. For many companies, their database is literally an electronic representation of the company's business and records and losing any bit of data during migration is unacceptable. There are several business reasons for moving data, some of these are archiving, data-warehousing, moving to new environment, platform, or technology. Database migration is a complex, multiphase process, which usually includes assessment, database schema conversion, data migration, and functional testing. Online Transaction Processing (OLTP) databases are usually much normalised for efficiency by performing tasks like providing data Integrity, eliminating data redundancy and lowering record locking. But this database design system presents us very numerous tables, and each of these tables and its foreign-key constraints must be accounted for at the point of data migration. Also, the Acceptance criterion for a data-movement job unlike conventional tasks is purely 100% because errors are not tolerated in databases and quality is important. This thesis demonstrates the challenges and considerations during the migration of data from a slow, inefficient and obsolete database-platform called Paradox database into a much more advanced database called Oracle that has successfully migrated the data. Indexing technique was used to improve the performance of a query by retrieving the data at a rapid speed without any inconsistency and loss of data. Keywords: Data Migration, DBMS, Data Integration, Database Migration Tools